Hi, I need some help please with a Macro that will run through a spreadsheet and perform a find a replace, but I need to be able to build a list of possible words and replace them with a newer version of these.
I have created a spreadsheet with named range lists, unfortunately these lists have had to be change and rather than change every sheet would prefer to use a macro that could change the data within the sheets, the data will be copied from the old sheets into the new sheet, as some of the columns have changed as well, I would then like to be able to run the macro to update the cell values.
old Value | New Value
2 | 2-High
Test | Testing
Any help would be really appreciated.