Quote:
Originally Posted by philipq
Greetings Friends,
Below shown is part of a pivot table.
The data range is actually huge to the range of 58,000 plus records.
These are call center data spooled from the server to excel.
Now, I need to filter only those in the labels that end with:-
FORD
JLR
FM
POC
FER
MAS
How do I go about doing so?
Can this be accomplished easily via some VBA method other than on a pivot.
Kindly refer attachment for the pivot table |
Shouldn't you have any solution yet, may I put some questions for a VBA procedure:
1 - Does "-" always precede the suffix?
2 - do you want the selected records copied elsewhere or
do you want the unselected ones hidden?
Bruno