I have a number of Pivot Charts that each have their own Pivot table but I need the user to select the page required from one pivot table and this selection to be used for the rest of the Pivot tables. I know that I can use VBA to specify the selection for any individual pivot table but how would I call this code or is there a better way.
?
Thanks
?
Thanks