I am wondering if this is possible.

First I have an Excel Workbook with 3 sheets. Sheet1 that is loaded with data. Each ROW is an independent set and the columns list different pieces of date for each set. Example…

Jeff | jeff@email.com | phone number | abstract | more data

I run a macro that looks at Sheet3 for keywords. The macro then searches column P in Sheet1 for those keywords. When the macro finds a keyword in column P, the macro copies the whole row and pastes the row in Sheet2. End Macro.

The data in each cell of column P is an enormous (~ 1000 words) abstract. Instead of reading the whole abstract, I can glean the required info by reading a few words around/near a constant set of 3 words. Example…

Constant set of words: red, fox

Yesterday I saw a fox jump over the fence. The fox was a very odd shade of red.

Is it possible to create a macro that, when asked (a button?) will copy the abstract, paste it in MSword, run a search (in MSword) and highlight each of the words (red, fox)? I can then quickly see the words (red, fox) in MSword, read the words nearby and get the required info without reading the whole abstract.

Ideally the macro would run on one cell at a time on demand.

Thoughts? Any help would be greatly appreciated.