Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste non merged to merged cells | Excel Worksheet Functions | |||
How can I sort an Excel Doc containing merged & non-merged cells? | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |