+ Reply to Thread
Results 1 to 3 of 3

One filter/ Master filter for multiple pivot tables...

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Danielson, Connecticut
    MS-Off Ver
    Excel 2007
    Posts
    9

    One filter/ Master filter for multiple pivot tables...

    I have Excel 2007. I am currently working on a problem where a user has 5 pivot tables, all of them show various data, but they are using the same data as a filter. Is there any way I can get all of them to filter when I filter PivotTable1? I have seen some code in other threads for macros, but I haven't found anything that has worked for me yet. HELP!
    Attached Files Attached Files
    Last edited by jlworden; 04-09-2013 at 04:36 PM. Reason: Question solved!

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852

    Re: One filter/ Master filter for multiple pivot tables...

    Have a look at this:

    http://blog.contextures.com/archives...one-selection/
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    01-09-2013
    Location
    Danielson, Connecticut
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: One filter/ Master filter for multiple pivot tables...

    That worked perfectly for this! Thank you so much!

+ Reply to Thread

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