-
Finding string in Word, searching for it in Excel column - if found, replace in Word
Hi guys,
I need help with Word macro that would do this:
Find a STRING OF RED TEXT in Word Document (red strings are located at the beginning of table cells)
Search for this text in Excel column and:
- If string is found, select that Excel cell and paste its content as plain text to Word – replacing the whole cell contents in Word cell. It is important now to make this cells text BLACK in Word - or otherwise cell "catches" red color due to plain text paste.
- If string is not found, then just continue with finding next Red String of text in Word, till the end of Word document.
Pictures can make you understand it better, I think:
Picture before macro:
Before.jpg
Picture after macro:
After.jpg
Thanks for any help, I really appreciate it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules