I need a quick an easy solution for microsoft excel.
The issue - I have 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.
I know this is possible because I did it previously? - I can't figure it out again.
So I want ONE drop-down/method? that will control up to 25 different tables on different worksheets in one workbook.
Also the developer needs to be able to explain how it works very very clearly so I can use this solution with other projects.
DO NOT BID OR REPLY TO THIS UNLESS YOU KNOW THIS CAN BE DONE!