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