Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
linking word doc to excel spreadsheet
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
linking word doc to excel spreadsheet
On Dec 14, 9:12 am, 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 Thank you. I'm amazed at how easy that was! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking a graph from an excel spreadsheet to a Word Doc | Microsoft Word Help | |||
Linking an Excel Spreadsheet in Word | Microsoft Word Help | |||
excel spreadsheet to word doc | Microsoft Word Help | |||
excel spreadsheet into word | Tables | |||
Excel Spreadsheet within a Word Document | Microsoft Word Help |