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.


Row Labels 1 2 3 4 8 10 13 14 15 Grand Total
ALA-ARA-FI 1 1
ALA-ARA-SAL-FORD 3 22 25
ALA-ARA-SAL-POC 2 21 23
ALA-ARA-SER 89 199 288
ALA-ENG-FI 1 2 3
ALA-ENG-SAL-FORD 2 2
ALA-ENG-SAL-JLR 1 6 7
ALA-ENG-SER 18 36 2 56
ALA-PARTS 22 11 33
ALQ-ARA-SER 6 24 30
ALQ-ENG-MAS 44 114 158
ALQ-PARTS 4 9 13
CEN-ARA-COM 202 325 527
CEN-ARA-FI 65 49 114
CEN-ARA-PARTS 91 96 187
CEN-ARA-SAL-FM 12 35 47
CEN-ARA-SAL-FORD 87 292 379
CEN-ARA-SAL-JLR 56 284 340
CEN-ARA-FER 266 614 1 881