Hi all,

I have a report in Word with pre-configured bookmarks within the document. In a separate excel sheet i have a list words in Column A and corresponding pre-configured bookmark name in Column B. What I would like the VBA to be able to do is find the word from column A in the word document and create a hyperlink to its corresponding bookmark from the bookmark name found in column B. Can this be done? Any ideas would help.

Thanks