Solved

Cross reference MS Words to Excel cell information

Posted on 2016-10-10
5
37 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

920 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

15 Experts available now in Live!

Get 1:1 Help Now