Ie 3 pivots on different sheets.
Pivot1 on the sheet Forecasting
Pivot2 on the sheet Hidden Pivot
Pivot3 on the sheet Hidden Pivot 2.
There are certain filters that I want to sync across. All the scripts I've found so far update/sync anything and everything.
Pivot1 has filters
Product - FIXED
Customer Name
Account Team Current
Account Manager Current
Culumative Time Period
Account Team Region Current
Pivot2 has
Fee Name
Product - FIXED
Account Manager Current
Account Team Current
Account Team Region Current
Culumative Time Period
Customer Name NOT A FILTER, IN ROW LABELS
Pivot 3 has
Fee Name
Product - FIXED
Account Manager Current
Account Team Current
Account Team Region Current
Culumative Time Period - FIXED
Customer Name NOT A FILTER, IN ROW LABELS
So for example in this current state I would want
Customer Name to link between all 3
Account Team Current to link between all 3
Account Manager Current to link between all 3
Cumulative Time Period to link between the first 2
Account Team Region Current to link between all 3
Bookmarks