Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable reference...
I have a spreadsheet with three pivot-tables. When an item is selected
in the first pivot-table the other pivot-tables items are changed. How can I reference a specific item in a pivot-table using VBA? Thank you, George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable reference...
Not too sure I understand the question, but the links below may help?
http://www.ozgrid.com/VBA/pivot-table-fields.htm http://www.ozgrid.com/VBA/hide-pivot-fields.htm -- Regards Dave Hawley www.ozgrid.com "George" wrote in message ... I have a spreadsheet with three pivot-tables. When an item is selected in the first pivot-table the other pivot-tables items are changed. How can I reference a specific item in a pivot-table using VBA? Thank you, George |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable reference...
Thank you for the reply and my apologies for such a poor explanation.
Pivot-Table00 holds months from last three years. Pivot-Table01 holds months from last three years (same Pivot-Table00). Pivot-Table02 holds months from last three years (same Pivot-Table00). I would like the ability to select a month from Pivot-Table00. After the selection is made Pivot-Table01 and Pivot-Table02 updates to the same month. I have the code working to check if the PivotItems are equal, but cannot figure out how to select a specific PivotItem from Pivot-Table01 and Pivot-Table02. Thanks for any help. ozgrid.com wrote: Not too sure I understand the question, but the links below may help? http://www.ozgrid.com/VBA/pivot-table-fields.htm http://www.ozgrid.com/VBA/hide-pivot-fields.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
reference of PivotTable | Charts and Charting in Excel | |||
Excel 2007 PivotTable "arbitrary shape is not allowed when its elements cross a reference dimension" | Excel Discussion (Misc queries) | |||
function to reference all of pivottable data field array | Excel Worksheet Functions | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming |