shinsplints
New Member
- Joined
- Dec 3, 2010
- Messages
- 1
Hi all,
I'm trying to figure out how to dynamically link a section in several Word documents (that will get updated weekly) to a spreadsheet showing a summary of those Word documents. Basically, the Word document contains status updates (among other things) of individual projects; I want to summarize all the status updates and comments sections in a spreadsheet so that I can quickly view the status updates in one place rather than opening each Word doc and scrolling to the section. When I open the Excel file, I want to be able to refresh the link so that it picks up the current contents in those field. I would assume that the section in the Word doc would need to be continually overwritten.
Is there a quick 'n easy way to do this?
I'm trying to figure out how to dynamically link a section in several Word documents (that will get updated weekly) to a spreadsheet showing a summary of those Word documents. Basically, the Word document contains status updates (among other things) of individual projects; I want to summarize all the status updates and comments sections in a spreadsheet so that I can quickly view the status updates in one place rather than opening each Word doc and scrolling to the section. When I open the Excel file, I want to be able to refresh the link so that it picks up the current contents in those field. I would assume that the section in the Word doc would need to be continually overwritten.
Is there a quick 'n easy way to do this?
