Transfer data from merged cells in excel [Closed]

Question

Transfer data from merged cells in excel [Closed]

Report

Princess z - Dec 24, 2008 at 11:14 AM
pseudonymph - Apr 2, 2009 at 05:46 AM

Hello,

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
Thanks

How to copy data from merged cells in excel
Merge cells shortcut excel ✓ - Forum - Excel
Excel macro to merge cells based on condition ✓ - Forum - Excel
How to copy data from one cell to another in excel automatically - How-To - Excel
Conditional formatting merged cells ✓ - Forum - Excel
Creating Shortcut key to merge cells - How-To - Excel

1 reply

Ask a question

pseudonymph · Accepted Answer · 2009-04-02T05:46:52-0400

Answer 1 / 1

pseudonymph
Apr 2, 2009 at 05:46 AM

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!

Transfer data from merged cells in excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!