Control Page to Update Pivots on Subsequent Tabs

Ok, I have a Control Page, with a drop down box. I want to be able to make a selection from that drop down box, and have all the pivots on the subsequent tabs update to the value selected on the drop box. Is this doable?

First, define the following dynamic named range...

Please Login or Register  to view this content.

This range will be used as the input range for your drop down. Note that the range will automatically adjust if you add/remove areas from your list. Then, format the drop down as follows...

Please Login or Register  to view this content.

Then, put the following code in a standard module. In the Visual Basic Editor, select your project from the Project Explorer window (Ctrl+R), and then select Insert > Module.

Please Login or Register  to view this content.

Lastly, right-click your drop down, select Assign Macro, and select the macro called "DropDown1_Change". A sample workbook is attached.

OMG Guru, you are soooooo awesome!!!! I would never in a million years figure out how to do that. Thank you! Thank you! Thank you!!

You're very welcome! And thanks for the feedback!

Cheers!