I am trying to create a worksheet that contains several pivot tables that are displaying information from various tables. They all have at least one field in common. On that sheet I would like to have a pulldown list of possible choices for that field. The user would then select the choice from the list and all of the pivot tables would then filter their results against that choice.
I've found a blog where the author (back in 2008) describes how this can be done by writing VBA code. Since then, MS has released Excel 2007, 2010, and 2011. Can what I'd like to do be done more simply with the newer releases or do I have to go the VBA route?