Hi all,
I'm looking for some help on a find and replace macro that creates consistency between company names. In general, sheet1 Column A will be "Oldtext" and Column B will be "Newtext". This list of old text and new text will grow over time as different variations come in.
For instance...