View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] louishong@lycos.com is offline
external usenet poster
 
Posts: 4
Default Synchronize PivotTable Items

I'm trying to synchronize three pivottables to be exact. The page-by
field was fairly simple.

Incase someone is trying to do this here's a real simple suggestion:

RVPName = PageBy cell name

PTName = Range("RVPName").Value
Sheets("Sales
Rep").PivotTables("SalesRepPT2").PivotFields("Regi onal
VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPH2H").PivotFields("Regional VP").CurrentPage _
= PTName
Sheets("Sales Rep Graph
Data").PivotTables("RVPPie").PivotFields("Regional VP").CurrentPage _
= PTName

What I cannot figure out is how to synchronize the items. If a
SalesRep drop-down contains John, Mary and Jane and the "master"
pivottable selects John and Jane I'd like the other two to do the
same. Is this possible? TIA.