+ Reply to Thread
Results 1 to 4 of 4

Two pivot tables one filter

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    14

    Two pivot tables one filter

    Hi All,

    I am trying to sync up two pivot tables in one worksheet so that if I select a filter item in one it changes it in the other and vice versa. I have found code that will link up all pivot tables in a workbook but I only want the two in the same worksheet to be linked. Can anyone help me?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Two pivot tables one filter

    Hi mshirschy,

    I wrote some code to do this a long time ago. See if this example helps.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Two pivot tables one filter

    Thanks for your help. Do I need to do anything else to this code? When I put into the code for the worksheet and then try to change a filter I am getting an error. I have absolutely not experience with VBA so unfortunately I think I need more explanation.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Two pivot tables one filter

    Hi mshirschy,

    You have VBA code that does what you want but you have no idea how the VBA works. If the code doesn't work, it seems you will need to change the code so it fits your exact problem. There is not "automatic" function in Excel that links two pivot tables together and has them both filter from changing the filter on one of them.

+ 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