Hi guys,

I would like some help with VBA/macro code. I need to copy undefined number of rows in one column to another worksheet.
In attachment there is an example how it should work, provided that the macro has to copy text on to another worksheet and number od rows is not known.

Copy ALL.xlsm

Thanks!