Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PivotTable - show top items | New Users to Excel | |||
PivotTable: Difference from Row Items | Excel Discussion (Misc queries) | |||
Unhide items in PivotTable | Excel Programming | |||
PivotTable Does not refresh individual items | Excel Programming | |||
PivotTable - calculated items? | Excel Discussion (Misc queries) |