I have 8 pivot tables all of which have a filter for choosing a company name. At present, I have to select the company name in every pivot table and I wanted to see if there was some VBA code to automate this so that when I choose the company name in one pivot table it automatically chooses the same name in the other 7. 4 of the tables are on one sheet and 4 on another although I could out them all on one if that would work.
I did find the code on youtube posted by Debra Dalgleish at contextures.com but it doesn't seem to work on all tables, only some of them. For example, I choose a company name such as Music & Arts and some of the tables change and then others pick random names.
Thanks
Gary
Bookmarks