*Before Moderators close this thread - it is a separate question to the two other posts I have under Excel Forum*
Hello,
I'm trying to push information from Excel to Word - I've got the macro/vba in the excel spreadsheet working, however when it hits the Word document it comes up with =TransferXYZ for every bookmarked section.
Can someone explain what I've done wrong in the Word Document. All of my researching lead me to believe that I needed to do a 'range' in excel, then to name the bookmarks the same 'range name' so that it knew where the information was to be dispursed.
I'm sure it's something easy, I just can't find anything on google to lead me otherwise.....
I've attached the excel spreadsheet - the macro code is BC Merge.
I've attached a saved copy of the word document that keeps getting produced when activating the merge.
Thanks - Pip
NCR Report - Coding Test.docx
NCR-CODING TEST.xlsm
Bookmarks