• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 57
  • Last Modified:

Cross reference MS Words to Excel cell information

Hi Expert,
I have a sample excel spreadsheet as attached like follow:-
And I have bundle of MS Words documents that will always refers to the following information.

Any methods that I can make at Words document to have cross reference / links to excel fields like bookmark etc that each time i updated Excel files, those WOrds documents with cross reference to those cell information will be automatically updated (Each time opening up the file?) Thanks.

(Refer excel attachement)
A1 = No
A2 = Project Title
A3 = Project Manager
A4 = Contract Number
A5 = Period

B1 = 1
B2 = Project A
B3 = Manager A
B4 = Cxxx001
B5 = Oct 2016 - Mar 2017

Regards,
KH
0
kunghui80
Asked:
kunghui80
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Please upload sample word and excel files.
0
 
kunghui80Author Commented:
Hi Saqib,
File attached in this post. Thanks!
SampleFile.docx
SampleFile.xlsx
0
 
GrahamSkanCommented:
I think you will need one document per project and link each 'field' on the document the cell on the worksheet

Select the target position on the Word document and then, select and copy (Ctrl+C) the relevant cell in the open Excel worksheet. In Word, choose Paste>Paste Special> Paste Link>Microsoft Office Excel Worksheet Object and press OK.
0
 
kunghui80Author Commented:
I'm trying this out, will update on this question again soon.
0
 
xtermieCommented:
You can always try to mail merge these two documents and create single documents
Once Excel is updated the main document will also be updated
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now