I have created a pivot table. I need to filter the "Column Labels" to only 3 entries. In this case I only need /403, /404, /405, and /406.
If I record the macro, it only "deselects" each entry I don't need one by one. This won't work with future data sets because those data sets will have entries that were not recorded during the creation of the macro.
Here is the code as I have it now:
Is there a way, maybe using some sort of if statement, that would deselect all the entries EXCEPT the ones I need?Please Login or Register to view this content.
Thanks,
Craig
Bookmarks