Copy non merged to merged cells
 

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

Copy non merged to merged cells
 

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

Copy non merged to merged cells
 

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 -

Copy non merged to merged cells
 

Closing thread
see http://tinyurl.com/arjuux


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59109