Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables and Macros
Hi,
I'm a newbie at pivot tables, but have been asked by my boss to create one for a bunch of end users who are even less computer literate than him! My pivot table is set up and ready to go, but I have 4 possible "value" fields that a user might want to see summarised within the pivot table. What I would like is to have a drop down box with the 4 possible values in, and everytime a user selects one - say "Actual Balance Outstanding" then it uses that data field within the pivot table. I can set up the drop down box using a validated list, but I am at a loss as to how I can then automate the field selection. Any suggestions would be really appreciated! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
do macros not like pivot tables? | Excel Programming | |||
Pivot Tables in Macros | Excel Programming | |||
Pivot tables and macros | Excel Discussion (Misc queries) | |||
macros and pivot tables... help please! | Excel Programming | |||
macros and pivot tables... help please! | Excel Programming |