Search for text and group rows in pivot table

[Dannypak]

Hello,

I am looking to modify the code below to search for a TEXT string rather than the row range as it appears.

Please Login or Register  to view this content.

I'm hoping to have this Macro search for "name*": any name that contains the text and group them.

I'm not sure if you can use * in VBA but any help on this work be highly appreciated!

Thank you,
dan