Export Worksheets

Hi guys,

I have a huge excel file with several worksheets.
I'm looking for a macro that would enable me to export only certain Worksheets from this file into a separate excel file.
The sheets are: "Overview", "Total", "Accounting", "Controlling", "HR", "Miscellaneous", and "Graph Input".

The output should take over the formatting of the original as well as the name of each tab, however not the formulas behind figures.
The name of the output file can be taken from Sheet ("Overview").Range("M17")

Any help would be very much appreciated!

Thanks!

It worked like a charm!!!

Thank you very much!

One short question still regarding this

Please Login or Register  to view this content.

As the output does not necessarily need to be a ".xlsm", I changed into a ".xlsx". However, I am getting a 1004 error on that line.

Cheers

Perfect!

Many thanks!