Excel Word Replacement Macro -- 2
Budget: $30 – $250 USD
I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur.
Key points you should build in:
• replacing about 20 words on one wb
I Should get a macro in an xlsm file that I can run on other similar files.
attache a file to be changed
a file with words to replace and their replacements.
an instruction letter
at the end I will check the macro file to see that all the replacements were executed.
Key points you should build in:
• replacing about 20 words on one wb
I Should get a macro in an xlsm file that I can run on other similar files.
attache a file to be changed
a file with words to replace and their replacements.
an instruction letter
at the end I will check the macro file to see that all the replacements were executed.