EdwardAveyard
New Member
- Joined
- Feb 9, 2015
- Messages
- 10
Is there a way to link an MS Word document with an MS Excel workbook so that changes to part of a table in the MS Word document will alter the value in a cell in the MS Excel workbook?
I'll explain the problem (with some details withheld to avoid violating security rules).
I'm creating a dashboard for performance for 150 organisations. A separate team are filling in tables in MS Word templates for how well these organisations are doing. For each of the 150 organisations, there will be a document containing a table containing a series of ratings (Red, Amber, Green).
I am in charge of collating this information.
I want to set up the workbook so that, when someone enters an organisation's rating as red/amber/green, the workbook will automatically update with this value. However, I don't know how to do this. I know how to go the other way (so that changes to an Excel workbook are automatically brought into a Word document).
Any advice would be greatly appreciated.
Thanks.
I'll explain the problem (with some details withheld to avoid violating security rules).
I'm creating a dashboard for performance for 150 organisations. A separate team are filling in tables in MS Word templates for how well these organisations are doing. For each of the 150 organisations, there will be a document containing a table containing a series of ratings (Red, Amber, Green).
I am in charge of collating this information.
I want to set up the workbook so that, when someone enters an organisation's rating as red/amber/green, the workbook will automatically update with this value. However, I don't know how to do this. I know how to go the other way (so that changes to an Excel workbook are automatically brought into a Word document).
Any advice would be greatly appreciated.
Thanks.
