Hi all,

I have a file with approximate 13,000 rows. In Column G, I would like to search for the word "DIGITSSE" (this word may repeat over 75 times or more) and when found, I would like the macro to copy the word "NC" to the left (in Column F) of the word "DIGITSSE".

As always thank you in advance for your support.

Cheers!