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.
Bookmarks