Pivottable reference...

  • Thread starter Thread starter George
  • Start date Start date
G

George

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
 
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.
 
Back
Top