|
09-15-2014, 10:00 PM
|
|
Novice
|
|
Join Date: Sep 2014
Posts: 5
|
|
Link cells in word doc (table) to update from 2 separate docs - can this be done?
I would like to have a Word “summary” document that can be set up to link or feed off table cells in other word documents.
I don’t mind if the update is automatic or needs a manual refresh of links.
I would like to do this to avoid double-keying lots of data & formats.
By way of example, I have included 3 attachments in a simplified format to illustrate what I am after.
- “Dept A – detail” – contains a number of cells, but I want the 2 cells (text and format) under “Controlled Risk” to feed the Summary document.
- “Dept B – detail” – contains a number of cells, but I want the 2 cells (text and format) under “Controlled Risk” to feed the Summary document.
- “Summary” – I want the specific data I noted above (text and format under “Controlled Risk” from the 2 different documents (Dept A & Dept B detail) to feed the respective cells here.
My example is simple, but this will have a lot more data for what I need.
Also, happy to have the Word “detail” documents feed an Excel based summary if that is easier.
It’s just preferable to have the detail template in Word as there will be some freeform text which is best suited to a well formatted table.
Hope someone can help.
I use Word 2010.
|