M
MikeZz
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!
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!