Thread
:
linking word doc to excel spreadsheet
View Single Post
#
2
Posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
Posts: 19,312
linking word doc to excel spreadsheet
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
Word MVP web site
http://word.mvps.org
wrote:
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
Reply With Quote
Graham Mayor
View Public Profile
Find all posts by Graham Mayor