Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one sheet to another "entry has to be same shape"
hi
when i copy dat in cell a1 in sheet1 (which is merged with cells b1 and c1) to cell d4 in sheet2, i get the message "data has to be same shape / size", although the dat fill fit into the destination cell. is there a way to overcome this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one sheet to another "entry has to be same shape"
des-sa
Just another bite of reality on the world of "Merged Cells". I would un-merge the cells you are copying and use "center across selection". They should copy and paste better. Hope this helps! Mike Rogers "des-sa" wrote: hi when i copy dat in cell a1 in sheet1 (which is merged with cells b1 and c1) to cell d4 in sheet2, i get the message "data has to be same shape / size", although the dat fill fit into the destination cell. is there a way to overcome this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one sheet to another "entry has to be same shap
just for interest's sake - what i did, that seems to work, is to insert the
same number of rows as are merged in source cell, then set the combined column width of the (say 6 rows) the same as the original one was. it seems as if the number of columns just have to be the same as source, even though the destination 6's width is much less than source. "Mike Rogers" wrote: des-sa Just another bite of reality on the world of "Merged Cells". I would un-merge the cells you are copying and use "center across selection". They should copy and paste better. Hope this helps! Mike Rogers "des-sa" wrote: hi when i copy dat in cell a1 in sheet1 (which is merged with cells b1 and c1) to cell d4 in sheet2, i get the message "data has to be same shape / size", although the dat fill fit into the destination cell. is there a way to overcome this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from one sheet to another "entry has to be same shap
des-sa
Glad you got it figured out, and thanks for posting your solution. Mike Rogers "des-sa" wrote: just for interest's sake - what i did, that seems to work, is to insert the same number of rows as are merged in source cell, then set the combined column width of the (say 6 rows) the same as the original one was. it seems as if the number of columns just have to be the same as source, even though the destination 6's width is much less than source. "Mike Rogers" wrote: des-sa Just another bite of reality on the world of "Merged Cells". I would un-merge the cells you are copying and use "center across selection". They should copy and paste better. Hope this helps! Mike Rogers "des-sa" wrote: hi when i copy dat in cell a1 in sheet1 (which is merged with cells b1 and c1) to cell d4 in sheet2, i get the message "data has to be same shape / size", although the dat fill fit into the destination cell. is there a way to overcome this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy data from a "parent sheet" to another | New Users to Excel | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
Data entry "+" results in "294" in XLS | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) |