Copy non merged to merged cells

  • Thread starter Thread starter jamalhakem
  • Start date Start date
J

jamalhakem

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
 
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
 
I see you have started a new thread, as you want to copy down rather
than across. See my response there.

Pete
 
Back
Top