View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeZz MikeZz is offline
external usenet poster
 
Posts: 152
Default Syncronize Autofilters on Multiple Tabs

Hi,
I found a way to sync Pivot Tables on different tabs but have not found any
examples of syncing Autofilters on different tabs.

Not all Tabs have the same fields.
What I want it to do on changing the Autofilter on a tab is:
Look through all other worksheets in book.
If sheet has autofilter and same column heading is found
Set that column filter to the one that I manually changed.
If field is not found, ignore.

Thanks!