+ Reply to Thread
Results 1 to 2 of 2

Pivot table to filter by selected cell in table

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    London, England
    MS-Off Ver
    Office365
    Posts
    22

    Pivot table to filter by selected cell in table

    Hi All,
    I am not sure if this can be done via normal formula(s) or needs a Macro or if it can be done at all.
    I have a summary table which contains a unique ID on the left. I then have on the right a separate pivot table which drills into one unique ID at a time. When I am reviewing each unique ID, in the right hand side pivot table, i have to click into it and search for the unique ID and select to refresh this table.
    Is there a way, that when i select the unique ID in the left table, this automatically updates the pivot table to drill down for that unique ID only so that i don't have to do that manually?
    I have attached a basic example of what i currently have.
    Many thanks in advance for any help.
    Attached Files Attached Files

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

    Re: Pivot table to filter by selected cell in table

    https://www.excelforum.com/excel-pro...-in-table.html
    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. Pivot table to filter by selected cell in table
    By pritesh118 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2019, 04:16 PM
  2. Selected pivot table filter items are not visible to VBA
    By dflak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2018, 01:24 PM
  3. Replies: 1
    Last Post: 10-10-2016, 01:17 PM
  4. Pivot Table How to make text box equal to value selected in filter
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2016, 10:38 AM
  5. [SOLVED] VBA filter Pivot Table to only user selected value
    By nigelbloomy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2014, 11:11 AM
  6. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  7. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 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