For roughly a week now, I've been looking for a way to copy and past cells from excel to word. this is how my set up is supposed to work.
1. I have a generic version of a document in word, and in it are things like "subject 1"
2. in Excel I have a spread sheet that has something like cell a1 = "subject 1" then cell B1 = whatever the subject actually is
I found and unsuccessfully tried multiple macros that will automatically replace the generic words in the word document with the specific words needed in the excel document. Doing the normal, find -> replace and repeat has been time consuming since there are roughly 22 cells of data that need to be searched and replaced in a 20 page document.
I tried following This Link's instructions, but it seems that I am just having trouble understanding how to do this.