Creating multiple excel copis as per the each sheet

[Shradharani]

Hi ,

I am working on one excel which has several sheets (Example = 40 sheets) .
After work is completing this excel I am creating different excels for each sheet that means I am creating 40 different excel files . “One sheet one excel.”
And saving these excels with name as each sheet name + adding some other wording (these will standard for each excels saved) .
For example if sheet name is “635000” file name would be “635000 repot for Timken US. “ So report for “repot for Timken US” will be common for each excel saved.

Can someone will help to automate this task by creating a macro.

Thank you,

[davesexcel]

You can use this,
Edit it to your requirements---
It will copy all sheets except Sheet1

Please Login or Register  to view this content.

[Shradharani]

Thank you ... Its working fine