« How can I setup my database on my localhost with Xampp to work with my website?
Has any one had Liposculpt by the Horizon Medical group in London? »

How do I insert text from a spreadsheet into a word document automatically?

I have spreadsheet that automatically gives me the next number in the header for my training sheets. This number is in cell C5 of the spreadsheet. When I open my word document I want it to automatically find the number in C5 and insert it into the header. Can you tell me the simplest way to do this automatically.

1. Open both documents (word and excel)
2. Go to the cell in question (C5). Right click, select COPY
3. Now open your word document. Insert the Header you want (or if you have already inserted it, then go into edit mode for the header). Inside the header, click and then PASTE SPECIAL (not just paste, but paste special). A paste special window should pop up. Click in the box beside "paste link" and then select "Microsoft Excel Spreadsheet Object". Select OK.
4. Save your Word file.
5. Close Word
6. To test it: Make a number change in Excel file (C5), save the file with the new number.
7. Now open the Word document. It’s going to ask you about updating links. Select YES. Your Header should now update with the new number from Excel.

This entry was posted on Sunday, December 6th, 2009 at 12:12 pm and is filed under insert into. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I insert text from a spreadsheet into a word document automatically?”

  1. 1. Open both documents (word and excel)
    2. Go to the cell in question (C5). Right click, select COPY
    3. Now open your word document. Insert the Header you want (or if you have already inserted it, then go into edit mode for the header). Inside the header, click and then PASTE SPECIAL (not just paste, but paste special). A paste special window should pop up. Click in the box beside "paste link" and then select "Microsoft Excel Spreadsheet Object". Select OK.
    4. Save your Word file.
    5. Close Word
    6. To test it: Make a number change in Excel file (C5), save the file with the new number.
    7. Now open the Word document. It’s going to ask you about updating links. Select YES. Your Header should now update with the new number from Excel.
    References :

Leave a Reply