range cells to row

[Evolta]

Hey,

I think my question is very easy to solve, so I don't have an example yet.

I have a three ranges of data
B19:B38
C19:C38
I19:I39

I need to transfer that to:
B19:B38 --> column 2, 5, 8, 11, ... 59
C19:C38 --> column 3, 6, 9, 12, ... 60
I19:I39 --> column 4, 7, 10, 13, ... 61, 62 (I39 needs to be put last)

How can I find a way to script this easily?

[ragulduy]

Please Login or Register  to view this content.

not sure where in column 2 you want it to go so change the 1 in cells(1,count) to the row you want.

That is for the first range, you can apply the same sort of thing to the others.

[Olly]

Try:

Please Login or Register  to view this content.

You don't specify which row to paste to - this uses row 1, so change as necessary. This does all 3 ranges in one pass.

[Evolta]

ah yes, this was what I was looking for.
might be the time and day but I could not figure out how to do this without writing 62 different lines.

The "1" depends on the situation, so that won't be a problem.

Thanks again and thanks for all the other times you helped me!