copying & replace from excel to word

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!