Re: Copy range to particular cell repetitively
I change the sheets as you told me, it works, but I forgot to tell you that the columns in sheet 1 are the F, G and H, from row 3...
Thanks for your help
Re: Copy range to particular cell repetitively
I change the sheets as you told me, it works, but I forgot to tell you that the columns in sheet 1 are the F, G and H, from row 3...
Thanks for your help
Hello! I have this boring task to do.
I have 3 columns with data (the rows in this columns are variable). I want to copy every row to another sheet in particular cells.
First row in sheet 1 to sheet 3 in A11, B11, G11, then second row in sheet 1 to sheet 3 in I11, J11, O11, then third row in sheet 1 to sheet 3 in A24, B24, G24, fourth row in sheet 1 to sheet 3 in I24, J24, O24, and so on.
So the used columns are always A, B, G, and I, J, O, and the rows increase of 13.