+ Reply to Thread
Results 1 to 2 of 2

Multiple Pivot Tables - Can filters be linked?

  1. #1
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421

    Multiple Pivot Tables - Can filters be linked?

    Here is my issue:

    I have two data sources - 1 being Agent Sales information - 1 being Agent Mileage and Payouts. The data cannot be merged for a variety of reasons. Subsequently I have a Pivot Table created for each data source....with both having a Filter that is Agent's Name, which would have the same dropdown options for both Pivot Tables.

    Is there a way to link one filter from a pivot table to mimic the filter from another pivot table - so as to not have to select the same agent twice? My intent is to add more data reports and ultimately more pivot tables, but all with the same Filter and would simply like to choose an agent once and all the filters for every table update to reflect the same selection.

    Thanks in advance.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Multiple Pivot Tables - Can filters be linked?

    I just answered this question in a different post. I modified that code. I haven't tested the final product
    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Macro to update pivot table filters from multiple pivot tables of different data sources
    By groblerdn85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2017, 05:10 AM
  2. Applying Filters to multiple Pivot Tables
    By TommyG85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2017, 02:12 PM
  3. Unable to apply filters to multiple pivot tables at once
    By karthikck in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-28-2016, 06:32 AM
  4. Selecting filters on multiple pivot tables
    By Mr_Phil in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-11-2016, 08:57 PM
  5. Automatic generation of multiple pivot tables, using different filters?
    By Greg Kinney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2015, 10:46 PM
  6. 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
  7. Pivot tables - Multiple filters across 2 tables
    By shoesterix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 05:02 AM

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