autofilter

M

minostrada

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.
 
M

minostrada

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?
 
D

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.
 
Top