+ Reply to Thread
Results 1 to 2 of 2

Macro to update pivot table filters from multiple pivot tables of different data sources

  1. #1
    Registered User
    Join Date
    11-24-2017
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    1

    Macro to update pivot table filters from multiple pivot tables of different data sources

    Hi there, I am completely new to VBA, I have two pivot tables with filters.

    The filters contain peoples names, and sometimes the names are the same but there are cases where one data source will have a name and the other will not.

    I am looking for VBA code that will update both pivot tables with the exact same name, and if it does not find the name in the second pivot table it should show blank.

    I have tried bits of code I have found across the net, and can get the one pivot table to udpate, but I cant get both to update, and blank.

    Any help would be appreciated, I am attaching an example workbook.

    Thanks,
    David
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Macro to update pivot table filters from multiple pivot tables of different data sourc

    Hi,

    You can't apply a filter to a pivot filter field that doesn't exist so making it blank will be tricky. Synchronising the filters that do match is relatively simple
    Please Login or Register  to view this content.
    If you would not ever be using filters on the row field, the code could perhaps filter the first row field for a value that wouldn't exist?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table from 2 sources/pivot tables?
    By LukasB in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2017, 08:25 AM
  2. [SOLVED] macro button to update filters and refresh pivot tables in other sheets
    By seanpcorbett1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2016, 03:48 PM
  3. Macro for linking filters with-in multiple pivot tables
    By Nick Simo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-12-2012, 03:36 PM
  4. VBA Pivot Table - Multiple Tables - Multiple Sources of Data
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:13 PM
  5. Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  6. Need to combine multiple data sources for pivot table [MDX query?]
    By needsomehelp3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2011, 04:32 PM
  7. auto update pivot table and/or filters when data changes?
    By soundengineer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2007, 12:08 PM

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