Multiple Autofilters

[swalker1961]

I know this sounds silly, but I had to ask anyway. I have multiple lists on the same worksheet. Is it possible to set filter for each list separately?

All the lists have the same heading, but the contents are different (can't explain that - too detailed!).

If there is a way, please let me know.

Thanks
Sam

 

[Juan Pablo González]

No, not with the Autofilter at least... it can only be active on one list at a time...

 

[swalker1961]

Thanks, but I did discover one curious list thing. When you have multiple lists with the same heading and apply the filter to the first list, Excel automatically applies that filter to all the lists. Cool!