Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic pivot table selection
Please bear with me, I'm sure I don't have the right lingo, but I'll give it
my best shot. I have a pivot table with page items. I want to be able to write a macro that will dynamically set a "page" item in the pivot table to what the user selects from a list on a data validation cell. So if the user selects Monday in cell A1, I want the pivot table for that page item item to change to "Monday". I know how to write code to change pivot items for a value that is predermined. ie I always want the page item to be Monday. But have never made the code dynamic and interactive with a value in a cell. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
Pivot table from dynamic refreshed pivot table | Excel Worksheet Functions | |||
Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names) | Excel Programming | |||
Dynamic pivot table | Excel Programming | |||
Pivot Table - Multiple Pivot Field Selection | Excel Programming |