I need help with a macro which loops

Macro search in Column F for Text Vendor Id and copies data down. If Cell
does not have Text "Vendor ID" I want to exit the loop.


Grateful for instructions on how to exit the loop. I dont know codes, I
just reoord the macro.

Thanks


Cristina