I'm trying to make a simple macro that searches through a worksheet (if possible a whole workbook) for a long list of words.
To make it simple let's say the words are:
cat
dog
wombat

For simplicity's sake let's say it would be searching column A.

If any of the words are found in column A, the word "check" will be placed column B in the same row it was found in.

I had found <a href="http://www.ozgrid.com/VBA/find-method.htm">this</a> and thought it may be a starting point for this code.

Not sure how to proceed, I'm willing to explain further details or even pay for this!