Auto Filter

[Roger R]

Is there a way to have two different auto filters on two
different columns that are not side by side? Or is there
a way to simulate this action without using autofilter?

 

[Dave Peterson]

You can only have one autofilter per worksheet.
You can have multiple columns per autofilter, though (duh?).

If you want to hide some of the dropdowns, you need some VBA code.

You can hide the autofilter arrow with something like:

ActiveSheet.AutoFilter.Range.Columns(2).AutoFilter field:=2, _
visibledropdown:=False

The second column in the filtered range won't have that dropdown.


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm