JamieLight
New Member
- Joined
- Jan 27, 2005
- Messages
- 3
I am looking to control a pivot table option from a drop down menu on another worksheet. I have a one page field on the pivot table which is 'Week01' to 'Week52' which controls all the options in the main body of the pivot table. I have set up a drop down menu on another worksheet, which contains the list of weeks 01 to 52, but I cannot control the pivot field....
I need advice on how to set up the change code...
I need advice on how to set up the change code...