Link to home
Create AccountLog in
Avatar of kunghui80
kunghui80Flag for Singapore

asked on

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
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Please upload sample word and excel files.
Avatar of kunghui80

ASKER

Hi Saqib,
File attached in this post. Thanks!
SampleFile.docx
SampleFile.xlsx
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I'm trying this out, will update on this question again soon.
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