Can this be accomplished easily via some VBA method other than on a pivot.
Kindly refer attachment for the pivot table

Attached Files

SAmple.xlsx (10.8 KB, 13 views)

If you call L1 'Row Suffixes' and use the following formula in L2 and copy down, you can then filter on that column:
=RIGHT(A2,6-FIND("-",RIGHT(A2,6)))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod,

Thank you for your response.

Yes, you are correct. However, is multiple label or value filter (all in one shot) possible using a pivot? From my findings using the pivot interface it is not. I was thinking maybe the pivottable object might allow for it via programming.

Best Regards,
Philip

I've rarely used pivot tables, so hopefully someone else can give more specific advice. I doubt, though, that even a VBA solution could avoid the need for a 'helper' column for the suffixes once it comes to actually generating the pivot table. Of course, if you add the equivalent formula to the data source you're generating the pivot from (yes, all 58,000 rows of it), or use a macro to generate the same output there, you could then generate the pivot table using the suffixes column instead of the labels column.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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