ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Way to display filtered results from more than one autofilter per (https://www.excelbanter.com/excel-worksheet-functions/86959-way-display-filtered-results-more-than-one-autofilter-per.html)

GS

Way to display filtered results from more than one autofilter per
 
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!

Pete_UK

Way to display filtered results from more than one autofilter per
 
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



All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com