NiccoExcel
New Member
- Joined
- Oct 30, 2015
- Messages
- 6
I have a single column range with strings of text similar to this:
LIST 1
<tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
LIST 1
COLUMN A | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> |
<tbody>
</tbody>
My list contains about 42,000 items. I need to replace words in this list with a predefined list of acronyms/abbreviations found on another sheet. like this: LIST 2
<tbody> </tbody> I need to create a macro that will review each item on LIST 1 and replace all words found in the "Definition" column of LIST 2 and replace the word with it's "Abbreviation/Acronym" counterpart. I want the macro to loop through each item on LIST 1 so I don't have to run it multiple times. I have tried recording a macro but I am not familiar enough with VBA to properly define the WHAT and REPLACEMENT parameters of the REPLACE method without selecting a static cell reference. Any help would be appreciated. Thanks! |
<colgroup><col></colgroup><tbody>
</tbody>