I have this problem for many years and need a big help! I have two pivot tables with identical page views. They are not using the same data source. What I need is whenever I select one page in one pivot table, anther pivot table will automatically select the same page. Is it possible by using VBA?
Thanks in advance.
Bliang
Thanks in advance.
Bliang