Excel Macro to extract sentences with a particular word
See the posting on my site at: http://soshea0.wix.com/litsupporttips...
. . . which includes a copy of the macro.
I found the below macro at: http://www.experts-exchange.com/Softw...
It can be used to find sentences in an Excel column which contain a particular word. Change the Range from
Range("A1", Range("A1").End(xlDown)) to show the cells at the top and bottom of the column with the text you are searching. This macro is set to look for the strings EMR and EHR. The search is case sensitive.