linking pivot tables by page fields

N

Nelson

Hello,
I have two pivot tables on the same worksheet that have the same page
fields. When I change one of the "pages", using the listbox, I often
forget to change the corresponding page on the other pivot table. I'm
wondering if there is a way to "link" these pivot tables so that when I
change one page field they will both automatically go to the same page.
Thanks for your help,
Nelson
 
N

Nelson

PS to my original post:
I've found some VBA code addressing my question, but I have no idea
where to put it! So, if the solution involves code, please be informed
that you're dealing with a neophyte and try to guide me through it
"step by step".
Ignorantly yours,
Nelson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top