linking word doc to excel spreadsheet

[patricia.scaccetti]

I have a spreadsheet with numerical data that gets added weekly. I
also have to do a narrative of that data for a weekly report. The
narrative has blanks (I can make these form fields if necessary) that
I need to have filled in with the new weekly data from the
spreadsheet. Short of manually coping the data is there any way to
link the doc with the spreadsheet and have those fields populate?
I'd appreciate any help with this.

Thank you,
Pat

 

[Graham Mayor]

Copy the cell(s) from Excel to the clipboard then edit > paste special >
unformatted text *as a link* into Word. While both the document and the
worksheet are open any changes you make min Excel will be instantly
reflected in the document. If Excel is closed you would have to update the
link fields to reflect any new data.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[patricia.scaccetti]

I have a spreadsheet with numerical data that gets added weekly. I
also have to do a narrative of that data for a weekly report. The
narrative has blanks (I can make these form fields if necessary) that
I need to have filled in with the new weekly data from the
spreadsheet. Short of manually coping the data is there any way to
link the doc with the spreadsheet and have those fields populate?
I'd appreciate any help with this.

Thank you,
Pat

Thank you. I'm amazed at how easy that was!

 

[Graham Mayor]

Thank you. I'm amazed at how easy that was!

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>