autofilter

[Guest]

does anybody know if it's possible two put 2 autofilters in one map?
at this moment i have them seperated in two maps, but i have to switch the
whole time.

 

[Ian]

Not sure what you mean by a "map", but it is possible to filter by more than
one column at a time. Select autofilter, then select the drop-down for each
of the columns you want to filter.

 

[Guest]

Ian,

I mean sheets instead of map. I'm using a autofilter at both sheets and it's
easier for me to create 2 autofilters next to each-other in one sheet. Is it
even possible?

 

[Dave Peterson]

You can filter one range at a time (on one sheet).

But if your ranges start on the same row, you can apply the filter to the giant
combined range and hide the arrows on the columns that aren't used (between the
two tables/maps). But you have to use code to hide those arrows.

Debra Dalgleish has a sample at:
http://contextures.com/xlautofilter03.html#Hide

Personally, I'd try to put all the tables on separate sheets--it just makes
updating (inserting or deleting rows and columns) lots easier.