+ Reply to Thread
Results 1 to 2 of 2

Copy/Match Table Filter to PivotTable

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2016
    Posts
    2

    Copy/Match Table Filter to PivotTable

    Hi,
    I have built a workbook template that will be used by multiple users at my business. It features a sheet that has an entire set of data (equipment costs and various cost factors such as fuel, hours of use, etc), formatted as a table (Table1), that can be filtered to show only relevant pieces of construction equipment using two slicers (category and description). This sheet is where users can modify data in columns as needed based on their use case to generate equipment rental rates.
    On a separate sheet, I have a PivotTable based on Table1. This sheet is used to format and print out the output of the users work in Table1 (i.e. calculated rental rates). Currently, users have to manually filter the PivotTable to show the same relevant equipment categories and descriptions that is filtered on Table1.

    I am trying to find a way to extract or copy the Table1 filter and apply it to the PivotTable.
    I know slicers can be linked to two or more PivotTables, but I have a Table and a PivotTable that need to match.

    Thanks very much in advance for any advice you may have.

    Chris

  2. #2
    Registered User
    Join Date
    05-08-2013
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Copy/Match Table Filter to PivotTable

    Bump - anyone have any ideas at all, or even a different way I could approach this?
    Need to maintain a table of data on one sheet, which will be filtered, and want to summarize this same filtered data on a separate sheet (ie. group by one column - category, then list individual items below each category).

+ 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. Automatically Filter Table to Match Between-Number Criteria
    By kcratskcor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2017, 02:34 AM
  2. Filter primary pivottable Data Model with parameters from another table
    By George_1990 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2017, 11:01 AM
  3. Filter by Top 6 and Other in a PivotTable
    By 1953CAG in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-27-2016, 03:11 AM
  4. Replies: 0
    Last Post: 03-14-2014, 11:06 AM
  5. [SOLVED] Filter Table to Match Column
    By danderson2692 in forum Excel General
    Replies: 0
    Last Post: 06-21-2012, 01:56 PM
  6. Replies: 0
    Last Post: 03-09-2011, 04:45 PM
  7. PivotTable Filter
    By yonyon7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2007, 09:03 PM

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