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
Configuration: Windows XP Internet Explorer 6.0
Active cell excel macro name not number Data counting in excel with different content Data counting in excel with different content and more than 1 column Excel function return cell address, increase row count Excel: how to transfer data sheet1 Find data on adifferent excel worksheet Formatting excel cell data with icons Function to clear cells excel 2007 How do i transfer data from a laptop with blank screen How do i transfer data from one xbox 360 hard drive to another How to read data merge cell excell in vb How to transfer data from one computer to another through router How to transfer data to an ipod using a universal data link to download my itunes If one cell is a value copy cetain data to another sheet excel Look for words in cells excel Merge cell contents into one single cell Openoffice excel shortcut merge cells Transfer data from pc to laptop using rj45