+ Reply to Thread
Results 1 to 3 of 3

Pivot and filter

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    Pivot and filter

    Hi,

    Is there a trick to link the search field in the Pivot to a listing outside of the pivot?
    I would like to filter all the items in the pivot by just 9 products.
    Currently, i m doing one by one and selecting 'add current selection to filter'. Sometimes i might miss the click and I need to start again Doh!

    Is there a way to get this done with VBA but that it can be used all the time, just thinking aloud.

    Thanks,
    josvilll2010

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Pivot and filter

    It would be simpler to add a new column to the source data that uses a formula to check if the relevant item is in your list. Then you can just filter the pivot table for that new field being True.
    Rory

  3. #3
    Registered User
    Join Date
    05-17-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Pivot and filter

    good idea. i will try that now. Thanks Rorya

+ 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: 1
    Last Post: 02-25-2018, 09:47 PM
  2. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  3. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  4. Macro to filter a pivot whilst looping through filter criteria in a variable list.
    By Alistairm88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2015, 04:25 AM
  5. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  6. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM
  7. VBA to change filter for n pivots based on page filter selection for the first pivot
    By shama.arige in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2011, 11:42 AM

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