How To Split Excel Sheets Into Separate Files | Session 6

[@vinaybadiger85]

It helped me to split 109 sheets given by client. Thank you! ❤

[@yunusdohad]

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

[@8k-quiz-splash]

And did this magic with 21 sheets

[@vexzed]

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

[@silviaberdan]

Thank you a lot for this useful information!

[@nickkampf8870]

thank you so much, i saw many videos on thhsi that had me downloading some sketchy shit, this is striaght and to the point. Thanks

[@KASC92]

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

[@Adejobiabiola]

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

[@charan0508]

Error in ws.copy

[@ManojLouis]

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

[@shalinidevi7773]

thank u, useful video and code

[@suruthish2450]

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

[@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

[@qubeil]

Good jooooob... very helpfull brother...

[@satyajitpatra7295]

Where I get the command

[@cariwagner8625]

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

[@qasimbintahir3331]

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

[@swatijain27]

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

[@sandy00718]

thanks this was super helpful

[@anupriyasingh3708]

How you paste the VBA command ..please explain this

[@nirmalbehera523]

Thank bro magic trick. From odisha

[@gonearpana6672]

Thank you. It helped.

[@saurabhkaka2445]

Nice dear.. Thank you

[@LoanNguyen-dh1bx]

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

[@cristopherjoseph380]

Hi plz tell how to master xl with basics

[@NiketSatapara]

How to do exact opposite of it?

[@suryaproabang280]

thank you sir you super helpful

[@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

[@SoniaAhuja-k3m]

where can I find VBA CODE?

[@aniketyadav2646]

Thnx Buddy , it does work.

[@discoveryourself7861]

very very helpful thanks boss

[@nareshpatel1035]

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

[@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?

[@ry3800]

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

[@osamamohammedahmed9260]

How can i get VBA file

[@ankitfreightcarrier1899]

Thank you helped a lot!!

[@johnyouseph4038]

thanks a lot, its helps me very well

[@futurebuddy9859]

superb sir thank you for the great information

[@innovativetechsj2417]

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

[@sudarshanbire1610]

HOW I WILL GET VISUAL BASIC APPLICATION (VBA)

[@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 👍

[@rohithjangam9994]

code should be copidable , here in description its not happening

[@farhodrahimov3365]

Thank you sir 🙏

[@niklims5133]

Thanks brother.

[@SabaKhattak-uc6oc]

Life saver,.... thank youuuuu

[@rebyam4249]

thank you very much

[@angeliamarkho8641]

its really helping me, thankyou

[@Simranjitchawla]

How to find code

[@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

[@RusselAshleyPascua-q1m]

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

[@midhunv7306]

Thank you😍😍

[@officialaccount6217]

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

[@simplecraft5486]

Thank you so much....

[@sumukhmutalik6107]

Thank you very much buddy

[@joaocruz2082]

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

[@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

[@TheJanus125]

Superrrrrrrrr

[@Cookexpert-xk5jx]

Thanks sir

[@gowrishm2564]

thats a greate answer...thank you

[@novitaalfiani5142]

Please help, why not working on mac?

[@abhisiktanag7221]

same here, throwing runtime error

[@mbs8854]

Share the code

[@vedantsartcraftanddrawinga4804]

Thanks

[@lithuanianv9847]

Legend

[@ashoksabbani9182]

Vba code plzz

[@bhagvatdake5796]

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

[@Tech-Infomedia]

Ws

[@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

[@8k-quiz-splash]

Thanks

[@srujanadwarapudi6055]

Thank you so much

[@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