Merged cells separte when pasted too.

D

DJONES

I have automated a form at work to accept data and print the complete
form. To do this I had to merge serveral cells to meet the form format
Now when I try to paste data into them some rows seem ok. If I try t
paste more then a couple rows of data at a time the cells will unmerg
and the data will appear in each cell.
For now I am pasting data to other cells not on the form and letting
formula ( =AB8 ect. ) move the data were it needs to be. Macros wor
also but I would still rather just paste the data were it needs to be
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top