search all rows for a word, group all rows containing word, and rename group.

[Dannypak]

Hi,
I had a similar task solved recently but am in need of help on another grouping task.

I have a 8000+ rows of data in pivot table, which I need to search for all rows containing certain words (there maybe serveral words in each cell, but I need to select all rows which contain the target word). Select those rows, group them and re-name the group with the target word.

wondering if this can be automated using VBA...

For example: in Col.B

The Bain company
Bain Company
Bain co.
Bain, Inc.

All of the above rows need to be grouped, replace the excel provided "Group1" tag with the name "Bain."

Looking forward to your help!

Best,
dan