paste rows between 2 sheets

[max_max]

Hi everyone.
I hope to explain myself.
In sheet1 there are a series of rows that must be pasted in sheet2.
We must copy:
rows 1/2 of sheet1 in row 1 of sheet2
rows 3/4 of sheet1 in row 2 of sheet2
rows 5/6 of the sheet1 in line 3 of the sheet2
rows 7/8 of sheet 1 in row 4 of sheet2
etc ... up to line 1001/1002
I attach an example
Thanks in advance.
max

[xladept]

Try this and let me know:

Please Login or Register  to view this content.

[max_max]

Hi xladept is not exact.
must paste the rows 1/2 in a single row

[Richard Buttrey]

And how would E3:E4 on sheet1 for instance appear in E3 on sheet2.

[max_max]

It is always possible to merge row 2/3 in one row in sheet2

[max_max]

In the new example attached in sheet 2, there is an example.
Now the row / cell union is given by =Foglio1!A3&" "&Foglio1!A4 (=Sheet1!A3&" " &Sheet1!A4)

[xladept]

[max_max]

Hi I attach example.
Merge row 1/2 sheet1 in row 1 sheet2
max

[xladept]

Maybe:

Please Login or Register  to view this content.

[max_max]

Hi xladept the macro work.
An error in cell = #NAME?
For n = 1 To UBound(P, 2): Q(s, n) = P(r, n) & vbCrLf & P(r + 1, n):

[xladept]

Hi max_max,

Your data is in error - try this:

Please Login or Register  to view this content.

[max_max]

Hi xladept now it's o.k, thanks you
A greting
max

[xladept]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

And, thanks for the rep!