View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default Synchronize Pivot table page fileter


Hi Andrew

Debra Dalgleish has a download at her site which shows how to do this.
http://www.contextures.com/excelfiles.html

Scroll down to Pivot Tables and download
http://www.contextures.com/PivotMultiPagesChange.zip


--
Regards

Roger Govier

wrote
Hi:
I have different tabs in a workbook that contains couple pivot table
sharing the same page filter. Is there a VBA function that I can
synchronize the selections by changing the filters on only one tab.
Thanks
Arale