hey guys,

I am not very good with VBA but learning..

I am trying to loop through a column in a document and when the word suit is found, I would like to copy and paste cell below it into another tab and continue to loop until blank row is found.

any help would be appreciated.