Search Word document based on text in Excel cell.
Smoking!
That did the trick, wasn't aware of the existence of it. Thanks.
It works like a charm, really.
IF possible, and just as nice to have:
-Is it possible to mark on the Excel sheet (lets say column D) if the sentence was found?
-My list of sentences was 42 items long, the highlight color ran out of options and went grey for the last ones.
Like I said, IF possible I would be VERY happy with point 1 and can live without #2.
Again, thanks Claus!
|