View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nico Nico is offline
external usenet poster
 
Posts: 25
Default How can you merge data from one sheet to another sheet which has .

Copy collumn by collumn or row by row or create a duplicate copy and unmerge
the merged cells first and then copy all

"monkeywakeboarder" wrote:

I have a document which has merged cells and I am trying to copy some
information into them but it keeps saying 'Cannot change part of a merged
cell' Can anyone help me? If I cant do this then Im going to have to
individually enter 2000 data entries....!!!