VBA to look for certain parameters in a word and populate a single data to excel

[Kartyk]

HI All,

Trying to explore a way to populate a column based on 3 other columns, details of which are also available in a word document. By matching the three parameters, code should pick the missing field and populate the excel. Challenges I see are :

* Data is not formatted in a table
* Converting it to excel is not also a viable option

Keeping the above in mind, is there way to work around this.

If the request is not very clear, i can send a model word and excel files for reference.

Cheers
K

[Kartyk]

Refer Excel file : Column C row # 2 in the excel file (highlighted in yellow) is the information populated from the word file. Column B, H & I are look up references
Refer Word file : Firm relates column B. Exch refers to Column H and C,dy refers to Column I. Based on these parameters, column C should be populated.

Word document will containhuge amount of data in the same format.

Hope this helps a little more.