Way to display filtered results from more than one autofilter per

G

GS

I have several tables in the same tab. I would like to be able to apply
independent autofilters to each table and display filtered results for
several tables at once.
I tried to search online but didn't find any tips on how to do this. Is this
possible in Excel 2003?
Thanks in advance!
 
P

Pete_UK

No, you can only have one set of autofilters active in one sheet at a
time. An alternative is to copy your tables into different worksheets,
then you can set up filters on each table independently.

Hope this helps.

Pete
 
Top