Copy data from one excel file to another, matching sheet names

[DachoR]

Hi guys,
I have two excel files with over 100 sheets each. Now I have to copy all data from one file to another, to match the sheet names, for example from excel file A copy data from Sheet1 to excel file B to Sheet1, and so on for all matching sheets.
Is this possible?
Thanks.

 

[narinder_73]

Here is a little trick you can use to quickly get snippets of code.
If you turn on your Macro Recorder, and record yourself performing an action manually (like inserting a blank row in row 1), then stop the Macro Recorder, that will give you VBA code that will do that for you. So you can view your recorded code, and copy/paste the section that performs that copy to your other code.

This is a great little tool that even us "pros" use from time-to-time (we don't memorize all this stuff).

Yes
very good
Thanks a lot
will do

 

[Joe4]

You are welcome.
Come back to us if you run into any trouble.