Mine is Excel 2010, but the user use Excel 2000, so I work in Compatibility Mode.

In my worksheet there are 4 PivotTables (pt1 to pt4) each has the same report fields, 2 rows ---> Year and Month.
For the time being, I make a code like this :

Please Login or Register  to view this content.
Cell B12 is pt1 report field of Year
B12.offset(0,4) is pt2 report field of Year
B12.offset(0,8) is pt3 report field of Year
B12.offset(0,12) is pt4 report field of Year

The same thing with B13, for the report field of Month.

So, if the user change any report field in pt1,
it will also change the report field of the rest PivotTables.
My code above is assuming that the user will always change the pt1 report field.

Problem, if the user change the report field not in pt1 but to any of the rest pt,
then the code above is useless.

So far, I've tried to add a MsgBox to let the user know that if he wants to change the report field, change it on the most left of pt.
But then the MsgBox appear a few times either the user change the report field of pt1 or the rest

My question,
how is the code so when the user change the report field of any pt,
the rest of pt's report field also change ?

Any kind of respond would be greatly appreciated.
Thank you in advanced.