Hi,
I am looking for a simple macro that would place an "x" into cell A when it encounters a word that is in cell B. When I say encounters, I also mean contains as there could be other words in cell B.
Once it encounters the word (in this case "judge"), it is to place an "x" in row A. Further, it is to continue putting
"x's" in cells below until it encounters another word (in this case "jury").
The small attached spreadsheet should clarify things.
Thanks.
Bookmarks