I have Table like this in word (main.docx)


My search cell may contain multiple numbers.
I would like to search for first line only in every case.

I have another database word/Excel (database1.docx/xlsx) file containing following table.

4818798 19970406 EXP.
4818798 19961112 REM.
4818798 19921116 ASPN
4818798 19920810 M183
4894153 19980118 EXP.
4894153 19970826 REM.
4894153 19930715 M283
4896965 20020130 EXP.
4896965 20010821 REM.
4896965 19970203 M184
4896965 19930630 M183
5021423 19990606 EXP.
5021423 19981229 REM.
5021423 19941117 M183
5107211 19960421 EXP.
5107211 19951128 REM.
5117870 19960602 EXP.
5117870 19960109 REM.
5185937 20010218 EXP.

Column one contains patent nubers
Column two contains event date in yyyymmdd formate
Column three contains event code in short formate.

I Want to search (i): US ([3-9][0-9,RE]{7}) in my word document and search for corresponding \1 result in database1 file and put column 3 ^13 column 2 data in (i+1) cell.

In case of multiple result from database file I would like to consider event code with latest event date. Generally it is first entry but if possible I would like to consider the date as filter as in future USPTO may change the formate.

After putting the event code in target cell (i+1) I would like to replace it with real event from another two column database2 word/excel file(database2.docx/xlsx. I just want to find and replace Event code with real events as in table.


Files can be found at:
https://sites.google.com/site/rtsk2015/fo

I am not able to attach it in my office as it is forbidden because of cyberoam.

Sorry for setting up strict requrement as I am at learning stage.