close

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
Hi Andrew

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

Scroll down to Pivot Tables and download
www.contextures.com/PivotMultiPagesChange.zip--
Regards

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()