Hi folks, been wrecking my brain on this.
Basically I want to copy and paste H1:H10 into C1:C10 and then pick next column of I1:I10 copy into next blank area of column C which is C11:C20; then copy next column J1:J10 into C21:30; then K1:K10 into C31:40 etc etc etc. This repeats itself for about 60 times from columns from H to BO.
So I am struggling picking a range of cells from column H after copying to move to next range on the right and copying into the next blank section in column C the target column.
Any help would be great.
Thanks,
Basically I want to copy and paste H1:H10 into C1:C10 and then pick next column of I1:I10 copy into next blank area of column C which is C11:C20; then copy next column J1:J10 into C21:30; then K1:K10 into C31:40 etc etc etc. This repeats itself for about 60 times from columns from H to BO.
So I am struggling picking a range of cells from column H after copying to move to next range on the right and copying into the next blank section in column C the target column.
Any help would be great.
Thanks,