How to Split Each Excel Sheet into Separate Files Easy (Excel 2003-2016)

Convert Each Excel Worksheet into Separate Excel File

[nicolerobben]

AMAZING! This will save me so much time in my work. Thank you for the tutorial!

[lunezza]

You save my working time too much. thank you

[flortirelli]

OMFG...you have just saved me ages of hard work. Thanks a lot!!!

[christysheehan]

You are an angel sent from above <3

[wajidalienvironmentalist]

Dear sir
In my laptop f11 is used for brightness button
When i press its decrease brightness.
I am stuck here

[DarylLewis]

This helped me a great deal with a piece of work, thank you

[prashantverma]

It is not working as i am getting below error please help


Runtime error 1004

we could not copy this sheet.

[sumanravi]

It's very useful but possible if I want to separate only active sheet not all sheets.

[nitinkhtri]

How can we split from pivotTable like I have many vendors how can i split from the pivottable data

[kHoPhAe]

doesn't work, can't debug sht.copy

[vidyashreeips]

Hi ... I want to split sheets, contains pivote table...excelsheets in to different workbooks... And it is not working with the given macro....pls suggest

[adrianaazizi]

When run, got some error and it is highlighting on the sht.Copy part. Can someone help me solve this problem?

[scottbennett]

I would consider turning off screen updating and changing the extension to .xlsx for newer versions.

[glitzjeeme]

Thanks but best.. if you write the instruction steps! press al..! an adarwon..! what was that?? sorry not understandable!

[wmartin]

This is Gold!!! But pls how do I perform this operation but I want the files saved in .CSV (comma delimited)??? I changed the .xls in the code to .csv, it worked but my out put csv is not "comma delimited"

[BladeRadio]

Absolute time saver!! Thanks for sharing your insight!

[puchanrattana]

greate ++ on the otherhand, How to combine each split sheet in to 1 sheet by separate work sheet

[nareshpatel]

I have more than 1 Lakh rows but with this VBA code i can see only 65536 rows showing in newly splitted files, Please help !!! just a note, i have changed .xls to .xlsx in VBA

[AdnanKhan-jlwh]

I have 180 branches information in a single tab. Now I want to create 180 different excel files in a folder for an each branch. Could u help me out pls?

[naseefcholayil]

Good tutorial, Thank you dear

But after splitting the sheets, all previously merged cells have become unmerged in the new files.
can you please solve this problem