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?
|