Read data from one excel and write to other [Closed]

Report
-
Posts
2690
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 12, 2021
-
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 reply

Posts
2690
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 12, 2021
454
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!