Results 1 to 14 of 14

2007 PivotTable and filter on multiple values

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    33

    2007 PivotTable and filter on multiple values

    I have generated a PIVOT table and it has field called "Current Handler".

    The complete "Current Handler" list has more than 200 names and I want to filter on my team member's name. The names of my team members are available in "Team List" sheet in the same workbook.

    If the "Current Handler" is a single name, then I can solve the issue using macro record operation and it seems to work fine also.

    1. There are some cases where "Current Handler" is a combination of several names (generally not exceeding 5, but lets not be limited by this)
    2. When multiple names are present in "Current Handler", the names may or may not all belong to my team (Team List sheet in same work book)

    The problem
    How to select all the names that belong to my team irrespective of whether they are standalone or exist as as combination of names?

    Thanks.
    Last edited by NBVC; 11-23-2011 at 09:08 AM.

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