| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syncronize Autofilters on Multiple Tabs
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "MikeZz" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| syncronize files | Excel Discussion (Misc queries) | |||
| How do I create multiple Autofilters in a Spreadsheet with lists | Excel Discussion (Misc queries) | |||
| How can I syncronize Autofilters on multiple sheets? | Excel Programming | |||
| Syncronize excel with outlook | Excel Worksheet Functions | |||
| Userforms and autofilters - Autofilters don't seen to work with userform | Excel Programming | |||
Linear Mode
