I am trying to find a number of instances and replace them from a range of
data. My range is in the Info worksheet and I want it to check my latest
data (active worksheet) and replace any instances where needed. Info- Column
A has possible data errors and Column B has the corrections. Current active
WS needs to be checked for the data errors and have the replacements put in.
The data range will vary as errors continue to popup with spelling/name
problems. Any help would be appreciated.