change multiple pivot tables on 1 sheet

Hi all,

I have a sheet called "Report" which contains 3 separate pivot table all with the common field "Division". I would like the other 2 pivots to change to the Division I select from the field called "Division" on the first pivot table without having to select them manually.

Any help gratefully received.
thanks
x

Right click on your Report tab and choose View Code. Paste the following.

Please Login or Register  to view this content.

thank you MDBCT, much appreciated !
Lucy.