Hi Otto
Thank you for repling back. All the words will be in "B" column from B50
to B850. Once it finds the word, I would like it to copy that single row
from column A to column Q to column "AA1". The word may appear couple of
times in "B" column so it will have to copy the next row at column "AA
2"
*** Sent via Developersdex
http://www.developersdex.com ***