Copy Sheets from another workbook.

[CoSinus]

Hello together,
my request sounds simple and I hope it is simple.
I need a script that copies 2 excel sheets together.
When the script starts, an Explorer window should pop up, with which I can call the 2nd Excel-Workbook.
If the book is selected, all contents from the selected workbook should be copied in a way that the contents within the sheets that have the same name as the sheet in the already open workbook are copied with one line spacing below the contents.
This means that only the contents of the sheets with the same name as the sheet in the already open workbook should be copied under the already open sheet with one line space in between.
If there are sheets which do not have corresponing names, will be ignored.
It suffices to copy the formatting and the values. I do not need formulas.

I hope you can help me.
Thank you very much.

[Mumps1]

Try this macro. The destination worksheet must be named "Summary" and a sheet with that name must not exist in the source workbook in order for this macro to work properly.

Please Login or Register  to view this content.

[CoSinus]

Many thanks for the excellent script.
It works great.

However, it copies all data of the selected 2nd workbook into the 'Summary' sheet and not under every single sheet with the same name as the selected sheet.

The script should compare which sheet names of the two excel files match and copy the data of the selected 2nd workbook separately to the corresponding sheets under the existing data.

I apologize if I misunderstood what I said in the first post.

Many greetings

[Mumps1]

Try:

Please Login or Register  to view this content.

[CoSinus]

This is perfect.
It is exactly what solves the problem.
And I can use the other script as well.

Thanks al lot you are awesome.
I bow to you.

[CoSinus]

I just found out one more thing.

Is it possible to copy the mismatching sheets from the selected workbook also to the original workbook with the same sheet name
So I merged all information from the 2nd sheet into one.
Those that are matching and the additional ones.

Thanks again very much.

[Mumps1]

Try:

Please Login or Register  to view this content.

[CoSinus]

This hits the spot.
Thanks again.
You're great and my hero.

[Mumps1]

You are very welcome.