Two Pivot Tables One Filter

[workindan]

On one sheet I have two pivot tables drawing from two different data sources...however, both data sources use the same list of names, therefore the "Name" field in both pivot tables have matching data.

PivotTable1 is the main table with various breakdowns, PivotTable2 contains some higher level summary data from another dept...

How can I get PivotTable2's "name" filter to refresh and reflect PivotTable1's "name" filter every time PivotTable1 is changed? I am also using a slicer to choose each person for PivotTable1.

I've tried doing worksheet_change and automating it, but this of course leads to an endless loop and a crash.

Thoughts?

 

[Jerry Sullivan]

Hi workindan,

I've tried doing worksheet_change and automating it, but this of course leads to an endless loop and a crash.

To prevent an endless loop when using events, temporarily set the Application.EnableEvents to False...

Application.EnableEvents = False
'.....your code that might trigger other events
Application.EnableEvents = True

Sounds like you have a pretty good idea how to solve the rest of your question once you overcome that part. Let me know if you need any more help.

 

[workindan]

Yes sir, that did the trick. Thanks for the help!