A VB script is needed to run in an Excel Macro that can look up a specified Word document (See Example attached). It needs to find a table that matches that in the example and pull out 4th column in the table for the matching row number.
Detail / Process Flow
1) Open the Excel and a Prompt for the Word file is presented on open for first time. Once selected this will not prompt for the second time open. That is it needs to save the selection for next time.
2) Script need to find the table that has 4 columns with those headings
3) Script needs to go to each row and test column 1 against the row 1 in the excel.
4) If script finds a match it needs to copy all in column 4 contents in its format back to the cell in Row 2 of the Excel.