Excel Word Replacement Macro
Budget: $250 – $750 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: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to exclude. • Usability: one clearly labelled button or a shortcut to run the macro, with a brief message box summarising how many replacements were made. • Clean code: comment your logic so I can tweak column references or sheet names if needed. Deliverable is the .xlsm file (or a .bas module) containing the fully tested macro, ready for me to drop into my workbook.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Visual Basic for Apps
Excel VBA
Excel Macros
Data Management