Locate the word and autocomment

Hello,

what I basicly need is

Lets say there is "noobs suck" randomly written on A1 to A1000 among many other words.

I need a macro to search for "noobs suck" in whole sheet, when it locates it, it should write "Noobs do not suck" on D column at same row that it's located.

I am sure it's something easy but I just lack the knowledge for it. Thanks a lot !

Hi,

One way is the following macro:

Please Login or Register  to view this content.

HTH