Hi!
In one of my worksheets I have defined two pivot tables and two XY scatter charts:
"HD2_Pivot" and "HD2_chart"
"HD3_Pivot" and "HD3_chart"
I'm trying to write a VBA macro which updates one of these charts whenever the respective pivot table is changed, using the "PivotTableUpdate" function. In my macro I define following parameters:
Set pt = PivotTables(x)
Set cht = ChartObjects(y).Chart
where I want to achieve the following:
IF HD2_Pivot table is updated:
x = "HD2_Pivot"
y = "HD2_chart"
ELSEIF HD3_Pivot is updated:
x = "HD3_Pivot"
y = "HD3_chart"
Is there any way to know / find out which one of the two Pivot tables were updated?
Best regards,
David
Bookmarks