Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy paste 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 paste non merged to merged cells
In what way does this differ from the post I've just responded to?
Please don't multi-post. Pete On Feb 5, 3:40*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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste into merged cells | Excel Discussion (Misc queries) | |||
Copy/Paste formulas in merged cells | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks | Excel Discussion (Misc queries) | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |