Pasting to next empty cell

Hi guys,

How do I copy columns of data to a new workbook starting from cell(1,2) and keeps pasting to the first empty cell in row 1, rather than hard-coding them to cell (1,2),(1,3),(1,4)...etc


Thanks
Hallet

Maybe something like:

Please Login or Register  to view this content.