Multiple find and replace per data group in the same worksheet

[terryhenderson]

Dear All,

I have one worksheet, as per attached example, where there is four columns: Col_A, Col_B, Col_C and Col_D.
Col_A and Col_B have the find and replace strings which belong to every group of 32 names in Col_C. Real data in Col_C are over 100 000 rows divided into groups of 32.
What I am in a dire need for is to use the strings in Col_A to be found in Col_C and replaced with the proper equivalent from Col_B. The result should be placed in Col_D.
Please note that the find and replace process is done per each group only.

Can I get your precious assistance with this question, please?

Many thanks in advance.List_of_names_multiple_find_replace_per_data_group.xlsx

[skywriter]

Can I assume There's only 1 occurrence of a find name in each group?

[skywriter]

See Post #2.
I went ahead and assumed only 1 time per group.

[terryhenderson]

Sorry Skywriter for not promptly returning to you as I was away from my computer.
Your assumption hit the target 100%, yes, there's only one occurrence of a find name in each group.
I ran your script and it did yield the desired product in spectacular speed.
Thank you very much for such masterpiece that does save time.
All the best, and always ahead.
T.

[skywriter]

My pleasure.

Please click the Thread Tools drop down box above your first post and choose solved.

[terryhenderson]

All the best..