Solved

Cross reference MS Words to Excel cell information

Posted on 2016-10-10
5
53 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 18

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

695 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