I would like a macro to perform many find and replace actions using a specified list.
Posted on 2014-12-26
Please see the attached workbook. I have a huge number of find/replace actions to perform. I will always be replacing numbers with other sets of numbers. I would like to paste the data on which to perform the find/replace action in the "Data" worksheet, and list the old values being replaced and the corresponding new values in columns A and B in the "Old and New Values" worksheet - I only want the find/replace actions to be performed on the "Data" worksheet.
I don't need a copy of the old data to be preserved. Sometimes the number strings might be in brackets or parentheses - I want to preserve those, and just replace the numbers.