Way to display filtered results from more than one autofilter per

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Filtered Results Using Autofilter 2
VBA: How can I use a string variable as autofilter criteria? 4
Filtering Using Values In A Specific Cell 3
HELP: Use the autofilter result on one workbook to filter the next list on another workbook 6
Count the number of AutoFiltered records 6
Using Autofilter More Than Once 3
Autofilter and count on filtered data 7
with Autofilter on, display count results in lower left corner wit 1

Top