Read data from one excel and write to other

Closed
pinky - Feb 7, 2012 at 01:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 7, 2012 at 10:08 AM
Hello,

I am a newbie.

I am trying to find out if we can achieve the below scenario using macros.
We have 2 excels in our case.
Excel1 contains field values and data
Excel2 is empty and we need to write data from excel1.
Excel1 has different column names and Excel2 has different column names so we need to map columns in this two excel sheets and then insert data from Excel1 to Excel2.

Any help is highly appreciated.

Thanks.



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 7, 2012 at 10:08 AM
Hi Pinky,

"We have 2 excels "
Two Excel workbooks (the actual file) or two Excel worksheets (the tabs in a file)?

Excel 1 has data and excel 2 is empty. Now you want to move data (which data; ranges or columns or rows?) from excel 1 to excel 2. What is holding you back in doing that?

In other words: Please clarify your query.

Best regards,
Trowa