So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly. Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that. Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding. This worked for me hopefully it does for you aswell.
This was a life saver. I needed to create 95 individual files from the 95 sheets in my workbook. It was fast and easy using your vba script! Each file had to follow a specific naming convention, but I was able to tweak your script to get exactly what I needed. Thank you.
@@pearl4177 - Are you looking for an added step- automatically emailing each file to a specific recipient? I’m sure that can be done, but I don’t know how to do it. I only needed to upload all of my individual files to a specific drive.
Amazing! Thank you Sumit. Just saved me loads of time. It looks complicated but I just paused each step and then applied each action. Worked like a dream!!!
Awesome Tip - This is very efficient! I hate manual work and creating 100s of these files each quarter. Although I review these and it's done by my colleague but even reviewing each of the files one by one is a Pain! This is great, Thank you very much for this tip. You earned yourself a Sub! :)
wow.. it is awesome. thanks 1000 times you saved me! I was struggling to do this, but with your video, it has become very easy and simple .. thanks ..thanks..thanks.
Many thanks for this video and sharing the code! I managed to adjust it a bit for my needs and you just saved me and a friend of mine a couple of hours every week :D Cheers!
YOU SAVED MY LIFE! I was trying to run the module for the past hour and it was giving me an error and I COULD NOT figure out what it was. I had one sheet hidden!! thank you!!!
Thank you so much....I request you that if possible ....kindly make a playlist of these utility VBA code which are required in day to day office work..... I am sure many people are looking for such playlist....
Hi Sumit, thanks for the tips! When I run the macro it doesn't save the files and it shows "Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed. Do you know what went wrong? Thanks
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly. Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that. Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding. This worked for me hopefully it does for you aswell.
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly. Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that. Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding. This worked for me hopefully it does for you aswell.
Very nice & simple code sir. Please make a video for consolidate multiple workbooks having multiple sheets. Consolidated workbook should have multiple worksheets also
please tell me is it possible to split single sheet in multiple workbooks (on the basis of there is 75 districts in one column want different workbooks for each District )
I loved the video but had to make a new sheet vs copy my old data file into the folder to avoid getting an error. If you want to save the files as CSV vs xlsx is that possible? I tried playing with the code and changed the line. Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".xlsx" To: Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".csv" but it doesn't populate the sheets until I change it back to xlsx and run that again. After it populates both the csv and xlsx files. I was hoping there was a way to make it populate the csv without having the run the program twice.
i am getting error path/file access error: :\VB8F8E.tmp' when code go to ws.copy every time i running the vba code this is find through step into (F8). Please help as three times this code executed but after it is showing same error . How we overcome this hurdle.
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly. Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that. Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding. This worked for me hopefully it does for you aswell.
Hi Sumit, If I wanted to take data from 1 tab and split it into individual files based on say different data in each cell So example if I have a list of groceries with prices all in one tab. Can I save individual files by category of groceries ?
DUDE!!! YOU ARE MY NEW GOD HERO!!!!!!!!!! You literally just shaved HOURS off my work for a monthly task . . . so FREAKING COOL!!!!
Simple and amazing trick...your attitude to help others is saving so much time of everyone...may lord swaminarayan bless you with peace...
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly.
Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that.
Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding.
This worked for me hopefully it does for you aswell.
This was a life saver. I needed to create 95 individual files from the 95 sheets in my workbook. It was fast and easy using your vba script! Each file had to follow a specific naming convention, but I was able to tweak your script to get exactly what I needed. Thank you.
Do you know how to share these files then via mail??
@@pearl4177 - Are you looking for an added step- automatically emailing each file to a specific recipient? I’m sure that can be done, but I don’t know how to do it. I only needed to upload all of my individual files to a specific drive.
@@pearl4177 - Try this video to see if it’s what you need: th-cam.com/video/1YMPltjyXeA/w-d-xo.html
@@KeithHarrison73 thank you Keith for the link..
Amazing! Thank you Sumit. Just saved me loads of time. It looks complicated but I just paused each step and then applied each
action. Worked like a dream!!!
Glad it helped 🙂
So fast and very helpful. I had to split out a very large workbook with many tabs and this did it in seconds. You are the BOMB!
Amazing video. Actually, it was an imagine till now but today it has come true only because of you. Thanks a lot.
As a teacher with lacking ICT skills, this was very helpful! thank you!
YOU SAVED MY LIFE, LITERALLY
Worked like a charm. Easy to follow instructions and the explanation of why you did it the way you did was helpful.
Idk how to thank enough... You saved my precious time 🥺
The information you provided was very easy to follow and time saving. Thank you very much!
Thanks I become expert in a split seconds!
thank you for your code!! i did my job done in a second!
I have nothing to say man ..🙏🙏🙏
U r video is ssrly working as a trump card for me...thank u so much
This is fantastic, save lot of my time. Big thank is not enough to show my appreciation.
Glad the video helped 😀
This was so great and I'm not a techie at all. Thanks so much!
Thank you! Such a huge timesaver! Easy to follow and simple!
GOLD. Pure GOLD. Thanks Bansal :)
This is really easy to follow!!! Thank you so much to make my life easier!!!!
Thanks a lot for this, it just saved me 2hrs work
Wow! This was simple and straightforward 👏 TY so much for making life “at work” so much simpler 🥰
This is not a simple help at free of cost. Really very helpful. Thank you.
Took me less than 5 minutes!! Thank you sir!!!
Glad the video worked for you 🙂
Thank you for making my life easier! It is very helpful for me.
Awesome Tip - This is very efficient! I hate manual work and creating 100s of these files each quarter. Although I review these and it's done by my colleague but even reviewing each of the files one by one is a Pain! This is great, Thank you very much for this tip. You earned yourself a Sub! :)
Thanks Man, Saved my days of work
there is no developer tab on my excel, what kind of excel are you using ?
This is awesome, works like a charm! Thank you, Sir!
Glad you found the video useful :)
This is a life saver. Thank you so much
wow.. it is awesome. thanks 1000 times you saved me! I was struggling to do this, but with your video, it has become very easy and simple .. thanks ..thanks..thanks.
You're a legend! Thank you sir!
Thanks Bansal, your code saved me hours of work (& of course manual entry error free). A great tip!!
Thank You. You save my time.
It's So fast and very helpful. Thanks
Many thanks for this video and sharing the code! I managed to adjust it a bit for my needs and you just saved me and a friend of mine a couple of hours every week :D Cheers!
Great job, thanks. Saved me a few hours of work
Glad you found the video helpful Gary 🙂
Just an observation: Unhide all the sheets before debugging the code or it will through error. Thanks for the video sir.
Thank you. It was a great tip
YOU SAVED MY LIFE! I was trying to run the module for the past hour and it was giving me an error and I COULD NOT figure out what it was. I had one sheet hidden!! thank you!!!
I don't have any sheets hiddin and it still showed me a bug in "Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".xlsx""
very helpful video great work🎉
This worked for me so well. Thank you
You have earned yourself a subscriber.
short and simpel and solved exactly what I need. Thank you, I'm now the hero of the day.
This is great. Is there a way to modify the code to work on Excel for Mac?
Thank you so much dear Sumit......it helped me a lot
Thank you so much for your work. I was able to save so much time with your code.
You saved me hours of work!!! Thank you!!!
Awesome feature bro !! Take a bow 🤠🤠
Thank you for the VBA code! Great work
Thank you so much. Its very informative & helpful.
Thank you so much....I request you that if possible ....kindly make a playlist of these utility VBA code which are required in day to day office work..... I am sure many people are looking for such playlist....
Have you found such a playlist? I would be interested in it too
Thank you, it saved my time and effort 🎉
bro it worked u saved my time thank u
nice.....It's possible to split Jan to Dec but 2 fixed worksheets with every Jan to Dec worksheets? please reply
Hi Sumit, thanks for the tips!
When I run the macro it doesn't save the files and it shows "Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed.
Do you know what went wrong? Thanks
Same for me
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly.
Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that.
Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding.
This worked for me hopefully it does for you aswell.
Thanks, man. It's a wonderful and awesome tutorial. I like this tutorial..😍😍❤❤🤗🤗💪👌👌😎🥰👍👍
How about if we need to save them all sheets in .csv format as well?
Thank you it saved me 30 mins
This looks great. However, I am experiencing a Run-Time error '1004' Method 'SaveAs' of object'_Workbook' failed - Can you help??
Please give a solution to this issues.
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly.
Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that.
Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding.
This worked for me hopefully it does for you aswell.
Hats off. you make life easy for me. I appreciate!!!
is the file dynamic? does it automatically change when you change the contents of the mother file?
You made my day brother....🙏🙏
I appreciate your effort in this video. Such an informative one. Thanks.
OMG TYSM SAVED MY LIFE FR
Glad you found the video helpful!
Thanks a lot brother...simple and fast ..keep it up
Hello, thanks for the video! a small doubt please, actually i need to copy the data validation link sheet also into the msplittled files, please help
Very nice & simple code sir. Please make a video for consolidate multiple workbooks having multiple sheets. Consolidated workbook should have multiple worksheets also
You're a superstar mate!
Thanks a lot my friend, you saved me a lot of work!
This is a great video, thank you!
Thank you so much for the direct, simple, and workable work, you saved so much of my time! 👏👏
superb. it's really helpfull thank you soo much.
Can I do this for a specific sheet only? And can I add custom path? Like it will create folder in that path and save it
Very useful trick sir, thanks for providing the VBA code it will help the user with little VBA knowledge. 👍
This is just an amazing. You helped me a lot bro. Many Thanks
please tell me is it possible to split single sheet in multiple workbooks (on the basis of there is 75 districts in one column want different workbooks for each District )
It can be done with VBA. You will have to create the code for it
Tried to run the code but it doesn't work on with Mac, getting errors. Can you provide the update?
Thanks a lot Sir.It works.Saved hours of works.
Wonderful. Works magic. Thanks.
👍
Thank you so much! This is awesome!
Hello, you saved my day, thank you a lot. . .
Is there a way to add a phrase in addition to the name? For example I need to add 2-24 subsidy to each one
Can we make changes to original workbook and will they reflect in splitted sheets after the split is done?
Very helpful man! Thanks a lot
THANKS, YOU FOR JUST SAVED ME SOME TIME |!!!!!!!
thank you sir.
i done split each excel sheet in multiple excel file.
NICE TRICK
:)
I loved the video but had to make a new sheet vs copy my old data file into the folder to avoid getting an error.
If you want to save the files as CSV vs xlsx is that possible? I tried playing with the code and changed the line.
Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".xlsx"
To:
Application.ActiveWorkbook.SaveAs Filename:=FPath & "\" & ws.Name & ".csv"
but it doesn't populate the sheets until I change it back to xlsx and run that again. After it populates both the csv and xlsx files.
I was hoping there was a way to make it populate the csv without having the run the program twice.
Keep up the good work. You saved me a huge amount of time.
thank you so much finally i found it.. Thanks really
i am getting error path/file access error: :\VB8F8E.tmp' when code go to ws.copy every time i running the vba code this is find through step into (F8). Please help as three times this code executed but after it is showing same error . How we overcome this hurdle.
So for those who are facing errors , i think i found a way to move around it , i was facing the same error , i think its because i copied the workbook and pasted it somewhere else . And maybe thats why it wasnt working. Then i created a brand new macro enabled excel in my desired location , i went to the initial one with all my sheets and data , select the first sheet , go to the very last sheet , "shift"+click on last sheet this selects the entirety of your sheets , then right click , move or copy , tick create copy , and select your brand new empty excel , you now have a new copy of your excel. Then use the macro , worked perfectly.
Now , this is just my theory , it could be that moving excels around copying and cutting could interfere with the macro , or having multiple other macros also affect its functionality but i doubt that.
Basically creating an excel in a folder and keeping it in that native folder without moving it around seemed to be the core for this , because the errors i was facing were path related , so maybe copying and moving excels around could f*** around with pathfinding.
This worked for me hopefully it does for you aswell.
This works..thank you for the help
Hi @trumpexcel I keep getting the following error - compile error: expected end of statement. What can I do to resolve this?
Amazing !!! Thanks a ton.
Thanks bro you deserve a sub very helpful
Do i every time paste that code in excel or it will automatically save for future
Thank Bro..., you are lifesaver
Thank you so so much! It's helped me :)
can this be done with numbers?
Hi Sumit,
If I wanted to take data from 1 tab and split it into individual files based on say different data in each cell
So example if I have a list of groceries with prices all in one tab. Can I save individual files by category of groceries ?
im looking for same thing, did u find it?
thank you for helping but problem is that if some workbook is hide this VB is not working, please help
Thank you! Can we do the opposite using VBA: combine a few workbooks into one? Please advise.