Hi all, I Have this code below looking at a specific cell, based on the name in that cell X7 (also stated as New Cat), The code selects that same name in the pivot table filter (Resource Pool Name).
By selecting this name the pivot itself displays data that is tied to this name.
Problem: If the name in X7 (New Cat) is not in the pivot, the code just shows all data for all Resource Pool Names (no Filter at all)
How do I update my code to do what it's doing but if the name in x7 does not exist in the pivot to just select "blank"
in the Resource Pool Name filter
![]()
Please Login or Register to view this content.
Bookmarks