andyboardman
New Member
- Joined
- Sep 12, 2006
- Messages
- 9
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
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