Hey folks,
I’m attempting to create a Find/Replace macro where I can populate the lookups/replacement into a table and then run the macro on a range finding the values from my table and replace them accordingly.
Here is an example:
I have a range with the following values:
Mélanie Fiona
Céline Dion
Selena Gomez & The Scene
I have a range of replacement values stored in a table in the following manner:
Column A
é
&
Column B
e
And
I’m looking to build a macro that will search for the values in Column A from my table and replace them with the value of Column B on a specified range.
I’m currently using the following macro as a direct replacement.
Any help would be appreciated.
Bookmarks