Solved

Cross reference MS Words to Excel cell information

Posted on 2016-10-10
5
33 Views
Last Modified: 2016-10-23
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
Comment
Question by:kunghui80
5 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 41836627
Please upload sample word and excel files.
0
 
LVL 2

Author Comment

by:kunghui80
ID: 41836636
Hi Saqib,
File attached in this post. Thanks!
SampleFile.docx
SampleFile.xlsx
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 41836906
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
 
LVL 2

Author Comment

by:kunghui80
ID: 41843080
I'm trying this out, will update on this question again soon.
0
 
LVL 17

Expert Comment

by:xtermie
ID: 41848335
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now