Read data from one excel and write to other

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 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
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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