How To Split Excel Sheets Into Separate Files | Session 6

This video will show you how to separate excel sheets into separate files.
Below VBA code can help to split multiple sheets of excel workbook to separate Excel files in very quick time :
1. Copy your file in a new folder which you want to split, because the split Excel files will be created at the same folder as this master file.
2. Press ALT + F11 keys on key board, and it opens the Microsoft Visual Basic Applications window.
3. Click Insert tab and select Module, paste the below mentioned code in the Module Window.
4. Press F5 key to run the commend, and the file is splited into separate Excel files in the same folder along with the original master file.
Note: Name of Main master file and names of sheets has to be always different otherwise this command will not work.
VBA Code :
Sub Splitbook()
'UpdatedbyTechtoday
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
xWs.Copy
Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

[@yunusdohad]

I had a workbook with 20 sheets - your solution was magical

[@cariwagner8625]

Thank you! Now I just need to filter on to seperate sheets first and maintain formatting! Great Video!!!

[@LoanNguyen-dh1bx]

Thank you so much for the instructions! It works great!!

[@vexzed]

Thank you this is a fast and simple solution. Very helpful, much appreciated.

[@ManojLouis]

Thanq Techtoday. It was such a help today. Indebted 🙏

[@Adejobiabiola]

Thank you so much for this video, I have stressed myself a lot when wanting to split it

[@ankitfreightcarrier1899]

Thank you helped a lot!!

[@KASC92]

God bless this person. I had so many sheets ;_; Thank you!!!!

[@sandy00718]

thanks this was super helpful

[@angeliamarkho8641]

its really helping me, thankyou

[@gonearpana6672]

Thank you. It helped.

[@johnyouseph4038]

thanks a lot, its helps me very well

[@ry3800]

it is the best one, I've subscribe in your great channel

[@futurebuddy9859]

superb sir thank you for the great information

[@aniketyadav2646]

Thnx Buddy , it does work.

[@gowrishm2564]

thats a greate answer...thank you

[@discoveryourself7861]

very very helpful thanks boss

[@sumukhmutalik6107]

Thank you very much buddy

[@suryaproabang280]

thank you sir you super helpful

[@qubeil]

Good jooooob... very helpfull brother...

[@simplecraft5486]

Thank you so much....

[@farhodrahimov3365]

Thank you sir 🙏

[@niklims5133]

Thanks brother.

[@saurabhkaka2445]

Nice dear.. Thank you

[@midhunv7306]

Thank you😍😍

[@lithuanianv9847]

Legend

[@cliffordhoper7403]

This is a great help, however, using this to split multiple sheets of excel workbook to separate Excel files fails to carry through the merged cells from the original worksheet. A real problem if you have many worksheets to split.

[@innovativetechsj2417]

Right sir same problem i fsce

[@vedantsartcraftanddrawinga4804]

Thanks

[@TheJanus125]

Superrrrrrrrr

[@AdnanKhan-jl8wh]

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?

[@anupriyasingh3708]

How you paste the VBA command ..please explain this

[@nareshpatel1035]

VBA stopped working when Sheet names with space and special characters , could you please help

[@joaocruz2082]

Thank you Sir , How to split Just per number of lines? 300 ,400 500 etc...

[@swatijain27]

From where do I get that text file to cpy this vba

[@charan0508]

Error in ws.copy

[@suruthish2450]

I have some doubt ..whether VBA work with libre office instead of Excel

[@jacky4sho]

for some reason i lost formatting in all sheets and the names of each sheet is giberish. Any way I can fix?

[@supermariochannel4182]

Help : how. To get two sheet in one work book eg ; maths and science in one work book and send it to one teacher via mail. Please make a video on this channel please thank you so much
2

[@officialaccount6217]

i cant split sheet that gebarated from pivot table?anybody has a solution?

[@cristopherjoseph380]

Hi plz tell how to master xl with basics

[@qasimbintahir3331]

its not working on my laptop because i have brightness button on F11 button so what should i do?

[@JONNEYBANSAL]

Hey I am not able to do it in Macbook, could you please tell me how I can do it its showing 1004 Error

[@sudarshanbire1610]

HOW I WILL GET VISUAL BASIC APPLICATION (VBA)

[@innovativetechsj2417]

Meri sheets un marged ho hai after useing this formula please help me out

[@osamamohammedahmed9260]

How can i get VBA file

[@rohithjangam9994]

code should be copidable , here in description its not happening

[@user-rv4pt9ri2u]

where can I find VBA CODE?

[@SabaKhattak-uc6oc]

Life saver,.... thank youuuuu

[@sultanrony4826]

Dear, variable is not declare here for xWs. Need declare ...Dim xWs As Worksheet ..so correct code may..
Sub Splitbook()
'UpdatedbyTechtoday
Dim xPath As String
Dim xWs As Worksheet
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
xWs.Copy
Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

[@user-oh6es2wb7n]

Hi, it's still not working :( The macro name is blank

[@Simranjitchawla]

How to find code

[@mbs8854]

Share the code

[@ashoksabbani9182]

Vba code plzz

[@moosa137]

Ws

[@novitaalfiani5142]

Please help, why not working on mac?

[@abhisiktanag7221]

same here, throwing runtime error

[@bhagvatdake5796]

You are explaing is too fast. It should be slow.

[@rekhapons3400]

Help : how. To get two sheet in one work book eg ; maths and science in one work book and send it to one teacher via mail. Please make a video on this channel please thank you so much

[@TechToday247]

Will come back 👍

[@supermariochannel4182]

Help : how. To get two sheet in one work book eg ; maths and science in one work book and send it to one teacher via mail. Please make a video on this channel please thank you so much
2

[@supermariochannel4182]

Help : how. To get two sheet in one work book eg ; maths and science in one work book and send it to one teacher via mail. Please make a video on this channel please thank you so much
2