LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Question Content Linking from MS Word Documents into Excel

Hello all,

I have a simple question and expect it would have a simple answer though solution may be a tricky.

Context: Link contents of two word documents into one excel spreadsheet

Problem Statement:

1. I want to create an excel traceability matrix which should link titles/contents of word documents and link them up in excel showing as some symbol that both are related (or change colour of which ever requirement has been changed).

In case if any requirement in either document is changed, excel should display through that symbol or as said change cell colour.

EXample- I have two word documents which have numbered requirements.

For ex-

a). Word_Doc_1.docx (first document)
i). FREQ_1 (first requirement in first document)
ii). FREQ_2 (second requirement in first document)

b). Word_Doc_2.docx
i). SREQ_1 (First requirement in second document)
ii). SREQ_2 (second requirement in second document)

I can create bookmark of all four requirements in both documents and can create a hyperlink in excel which will refer those but how to-

1. Set up the linking between them
2. Display the impact if any requirement changes?

Please do let me know if all you expert need any information which I missed. More than happy to provide.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
linking cells when embedding into Word documents Buck Jeppson Excel Worksheet Functions 0 February 26th 10 04:03 AM
Linking Cells Between Excel Documents Question Troubled Excel Discussion (Misc queries) 3 August 11th 08 05:48 PM
Too many word documents, can Excel HELP!!! Jerry Excel Discussion (Misc queries) 1 May 13th 08 08:07 PM
Help with linking excel database to various word documents sarah Excel Discussion (Misc queries) 0 March 26th 08 04:52 PM
Linking Excel-areas to word-documents Eirik Sævareid Excel Programming 1 December 17th 06 10:24 PM

All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"