Hi,

I want to copy a range to a new sheet, say Sheet2. The range has a fixed column number but varying row numbers. I copy this into a sheet with a specific address, say A1. Then I want to copy Range2 into the same sheet, Sheet2, in Column A, after where Range has been copied in, and in the next +1 empty cell Range is similiar as range 1, fixed number of columns, but varying number of Rows.

I manage everything apart from pasting Range2 into the row. I think it is difficult to copy into both a new sheet with a varying cell. If you can help with some ways of making a variable with Cells/range address, it may help!

Thanks a lot!