Linking PivotTable Fields - Excel 2007
 

I have two PivotTables that are set up on different data sources but with the
same report filters. Some of the report filters have multiple items chosen.
I want to change the report filter in PivotTable 1 and make sure the report
filters in PivotTable 2 are the same. I can't write a formula as both cells
read (Multiple Items). Any suggestions on how I can make it work?

Linking PivotTable Fields - Excel 2007
 

Excel 2007 PivotTable
Duplicate Report Filter selection in all PTs.
Macro.
http://www.mediafire.com/file/mhwhk1wgj1q/08_06_09.xlsm