I see you have started a new thread, as you want to copy down rather
than across. See my response there.

Pete

On Feb 5, 5:23*pm, Pete_UK wrote:
Do you mean that you want A1 and B1 from Sheet1 to go into A1/A2/A3
and B1/B2,B3 of Sheet2, and then for A2 and B2 of Sheet1 to go into C1/
C2/C3 and D1/D2/D3 of Sheet2, and so on? So that you are copying
across Sheet2 for cells that go down Sheet1?

If so, then you can put this formula in A1/A2/A3 of Sheet2:

=INDEX(Sheet1!$A$1:$B$450,INT((COLUMN(A1)+1)/2),MOD(COLUMN(A1)-1,2)+1)

adjust the range to match your data in Sheet1, and then copy across
Sheet2.

Hope this helps.

Pete

On Feb 5, 3:42*pm, wrote:



Hi
I have 2 sheets, in sheet 1 I have
A * * * B
1 * * * Name * *Number
2 * * * Name * *Number
3 * * * Name * *Number
Etc….
In sheet 2 I have:
A1, A2, and A3 merged, B1, B2, and B3 merged, etc…
Any way to copy and paste the data in sheet1 to sheet2 in a way that
in merged A1, A2 and A3 in sheet2 have the same data in A1 in sheet1,
in a way to copy and paste many columns, up to 900 columns, in an easy
way, not copying and pasting every cell.
Thanks in advance
Jam- Hide quoted text -

- Show quoted text -