Way to display filtered results from more than one autofilter per

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

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
emailing autofilter results 3
Copy Results from Autofiltered List 3
Using Autofilter More Than Once 3
VBA: How can I use a string variable as autofilter criteria? 4
Autofilter and count on filtered data 7
autofilter results based on cell input 5
HELP: Use the autofilter result on one workbook to filter the next list on another workbook 6

Back
Top