+ Reply to Thread
Results 1 to 1 of 1

Cell Reference Filtering a Pivot Table

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Question Cell Reference Filtering a Pivot Table

    Hello all

    I have a problem and could use some extra brain power to solve it.

    See attached as an example. I have a data set that has several pivot tables on it. Basically, in one pivot table I want to filter using the label filter 'contains'. The value of the filter is located in another pivot table. I want to reference this other pivot table to provide the value to do the filter by. Not sure how to do this. My end goal would be to create a list box that contains the values to be sorted by where you select a value and the pivot table column is filtered based on that value. Not sure how to accomplish this. Any help would be awesome!

    Thank you all very much!!!!

    -Byebye14
    Attached Files Attached Files

+ 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. Replies: 5
    Last Post: 07-01-2019, 08:01 AM
  2. Filtering a pivot table based on the value of a cell
    By fbonetti in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2015, 08:34 AM
  3. Filtering Pivot Table on Active Cell
    By shootamcgavin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2015, 08:18 AM
  4. Filtering pivot table based on cell value
    By torrmel9701 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2014, 03:48 PM
  5. Need help filtering pivot table by referencing cell
    By jcwehr2009 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2013, 07:06 PM
  6. Filtering a Pivot Table by cell value
    By booo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2011, 03:48 PM
  7. Filtering a pivot table based on a cell selection
    By ExcelJunkie101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2010, 12:06 AM

Tags for this Thread

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