Content Linking from MS Word Documents into Excel

[Lacks]

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.

Regards.
Lacks




--
Lacks