Pivot Tables - changing page fields automatically

[andyboardman]

Evening all - first post!

I have 4 pivot tables with either 1 or 2 page fields per pivot. On each table the primary (top) page field is called "Serial Number". On two of the tables I have a secondary page field called "RM Product". What I would like to be able to do is to change the Page field "Serial Number" and the Page field "RM Product" in the first of the 4 tables and then have the other three tables automatically update themselves.

Dave from Ozgrid posted a code a long time ago for someone else but I cannot get this to work - I do not have much VBA knowledeg other than using the macro wizard to make simple go faster macros.

Appreciate any help you can offer.

regards.............Andy

 

[mrhartley]

Hi,

I have never done this but I am sure I have seen this asked many times before, so failing an answer being posted, try some searches here and see what you turn up.

Regards
~Mark

 

[andyboardman]

Thanks - I did do this but did not throw up what I needed. I'll have to try again.