There is a workbook with many sheets, each of the sheets has multiple Pivot Tables on them.
Each Pivot table has a drop down with Multiple regions. What I want to be able to do is have a solution that will allow me to select a region and have that region filter in ALL the other Pivot tables.
So I want ONE drop-down that will control up to 25 different tables on different worksheets in one workbook.
Bookmarks