Transfer data from merged cells in excel

 pseudonymph -

I have a worksheet form in excel and I would like to copy the informaiton on the form to another sheet in a different workbook in excel as well.
I can write a simple macro or record to copy and paste the information over but the problem is that the first form has a field for ex First name and the text box has 4 cells merged together so when I copy that merged cell and try to paste it into the other worksheet which has 2 cells merged for the same name column it doesnt work.
Please help me how I can concatenate the cells together and paste it into the other one.
URGENT reply required

1 reply

If you select paste as.. "values and number formats" from the paste special menu you will be able to paste as values into merged cells.

Hope this helps!
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month