So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.

Yes, you seem to want, "Synchronizing Two Pivot Tables with One Combo Box"
covered in detail in pages 225-229 of Pivot Table Data Crunching by Jelen /
Alexander.

"Mike" wrote:

So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.

Anyone got any help that doesn't cost anything?

"trip_to_tokyo" wrote:

Yes, you seem to want, "Synchronizing Two Pivot Tables with One Combo Box"
covered in detail in pages 225-229 of Pivot Table Data Crunching by Jelen /
Alexander.

"Mike" wrote:

So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.

how about creating VB code that you can have a button ?

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
ActiveSheet.PivotTables("PivotTable2").PivotCache. Refresh

"Mike" wrote:

So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.

Excel 2007 PivotTable
Sync multiple PT Report Filters.
Show filter selection on PivotChart
With macro.
http://www.mediafire.com/file/ydwximyxjwx/02_02_10.xlsm

Hi Mike

Debar Dalgleish has some examples in her download at
http://www.contextures.com/PivotMult...DiffChange.zip

--
Regards
Roger Govier

"Mike" wrote in message
...
So in 2007, I have two pivot tables that reference the same data set and
have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any
solution/suggestion
is welcomed.

Thanks for any help.

__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com