I have a need to link a drop down/combo box to a pivot table
and would appreciate any ideas or techniques to get this done.
Sheet2: This sheet has all the line item details. For instance, A2 =
Country, B2= State , C3 = City, C4 = blah blah blah .. approximately
12 columns.
In sheet3, I've pivoted the data in sheet2 so that in the PAGE section
of the pivot are 3 options (Country, State and City).
In sheet1, this is where I have the 3 combo menu corresponding to the
3 options on the pivot in the same order (Country, State and City).
How can I change the PAGE selection of the pivot through the combo
menus in sheet1? I know I can leave it at pivot page and be done but
my clients aren't very pivot crazy and they've specifically asked for
drop down menu instead.
I would imagine this would require some VB scripting. Unfortuantely, I don't now much about VB so including simple steps would be very beneficial. Much thanks.
Matt
Bookmarks