Results 1 to 8 of 8

Macro/VBA to update multiple pivots with SOME filters

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    24

    Macro/VBA to update multiple pivots with SOME filters

    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
    Last edited by dogie; 08-21-2012 at 07:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1