Autofilter multiple tabs as the same time

[corpeat]

Just wondering....without using macros, is there a way to use the autofilter function across multiple tabs? For example, I have 3 tabs with identical information in columns a-c and have autofilters set over said columns on each tab. I'm looking for a way to update the filters on all 3 tabs simply by changing my selection on tab 1.

Ideas?

[meweaver27]

I don't think you can do this. When you use CTRL to highlight multiple tabs the AutoFilter function is disabled. Using CTRL is the only way I know how to make the same changes on several tabs at once.