How to create more than 100 Folders with a Single Click
A simple technique to create more than 100 folders using the names listed an Excel sheet is explained in this video.
🟠 Books on Excel xlncad.com/excel-resources/
🟡 Get Office 365 Subscription microsoft-us.evyy.net/3NE6y
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🚚Check my store on Amazon.
www.amazon.com/shop/ajayanand
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#MSOfficeTrick #ExcelTrick #ExcelTip
Пікірлер: 171
Thank you so much! I followed your very clear directions and was able to create folders for 2,800 students at our high school, after exporting names from our SMS. You saved me hours.
@AjayAnandXLnCAD
Жыл бұрын
Glad it helped!
Thank you so much! This is EXACTLY what I was looking for and your instructions were easy to follow and understand. So impressed!
I search for how to Create folders with sub folders. I am grateful to have found your video, thank you. I almost overlooked your video because I read your title which doesn’t include sub folders. Maybe #folder#subfolder, this might get more attention to your video. This video really saved my day. Thank you
Excellent ! Exactly what I was searching for. Clear and concise. Thank you !
Thank you, Thank you, Thank you. I have watched about 20 of these after my Macro stopped working and could not make sense of anything. I got it on the first try with yours. Thank you.
This was incredibly helpful. Thank you so much for making this guide; super easy to follow and execute!
AJ. Thanks so much for this, this was far simpler than the info on the MS Support Site☺which required admin access on my PC which I don't have. I just created 380 folders, each with 2 sub folders in a few simple clicks following your video along.
That was suprisingly easier than looking up how to make loops in batch files or even looking through Python for something to mass create folders. Thanks for this trick.
MUCH SIMPLER TO UNDERSTAND AND YOU HAD EXPLAINED POINT TO POINT NOT LIKE OTHER KZreadRS BLA BLA .... I REALLY LIKE IT
I can't believe I've been creating one folder at a time. this is going to save our guys in the field so much time. You Rock AJAY
OMG! best video ever. Thank you for posting this. It came in very handy when creating my ee files.
So amazing! It saves so much time and increases productivity. Thank you so much Ajay.
@AjayAnandXLnCAD
3 жыл бұрын
Glad you liked it
@balajisubramanian9940
2 жыл бұрын
Is there a way to do it on Google drive and also assign permissions
Easiest method I've found yet! Thanks :)
Thank you! Just what I needed, and other tutorials I found did not come out right.
Thank you, Ajay! You have made my life so much easier!
Truly amazing, was looking for this
This is sooo informative !! And adorable !! As usual !!🤗🤗🤗💜💜💜 Thank you, Mister Aj !! The champion !!😋😋😋😋😋😋😋
@AjayAnandXLnCAD
4 жыл бұрын
Glad to hear it from you and it's My pleasure, Miss MonteNegro 😊🙏
@adnanahmad3939
2 жыл бұрын
Q itan ghuamaya hay bhai ??? Yeh sidhi sidhi MS-DOS ki make directory ki command hay .. MD directory name ... Ab batch file ma hum jitni commands sequence ma daal dain woh sequentially isi tarha run ho jati hain .. is ma logon ko pehlay MS-Excel ma ghumanay ka kia faeda . Main khud 22 saal say computer field ma hun ... Magar asi bongiaaan dakh kar dukh hota hay .... Jo baat sidhi hay woh usi pattern par batani chahye .. is ko itna lamba karnay ka kia faeda ??. Ap 3 ya 4 baar MD directory name type kar ka woh bhi notepad main ... Usko direct saveas main ja kar .bat extension ka sath save kar kay run kar saktay hain . Result will be the same ... Ab ap chahay 1000000 names ki MD dalain sab ka rule aik hi hoga ...
1000X Thank Yous for this amazing folder idea!!!
Super easy, thank you so much for sharing
Wow. That was something new. I never knew it before. Thanks for the share.
@AjayAnandXLnCAD
3 жыл бұрын
My pleasure
Work like a charm, Absolutely genius thank you👍
WoW. So Great & helpful.
this is exactly the video i wanted
Thank you for sharing! very useful.
Excellent. Thank you.
This is way amazing then Excel Macros ...Beautiful !!! Superb !!!Iam your fan AA
Very helpful Thank you
what a legend! this is exactly what I was looking for thanks! 🤘🤘🤘
Awesome. Thank you so much!!!!
Additional Informative Video Ajay Sir Superb Explanation
@AjayAnandXLnCAD
4 жыл бұрын
So nice of you
This tricks might not be knowing several people . Thank for posting ... useful video
Incredibly helpful
superb really time saving trick. You have explained it well.
Thanks a lot.You saved our time
Thank you so much for this
Excellence! Thank you!
Thank you so much, I have spent 6 hours, searching the net for what you have explained in a few minutes. Many Many THANKS
Thanks a ton...only this video has worked for me❤
AWESOME, thank you!!
THANK YOU!
Thank You!
Great video - saved me hours of work :)
Great, very helpful
Wow!! You are amazing my friend..
Thanks for the video, what is the purpose of that MD before each folder name?
Omg who you are man...! You are really amazing and unbelievable...! 💗
Ajay you are a saviour.
Thank you very much.. very helpfulll
Hi Is it possible to duplicate a list of files within each subfolder? I use the same folder structure for projects, and would like to copy the names of files, so that eqach project has teh same set of files. Ideally, I would like to be able to put the project number in each file name.
Thank you very much 😊
amazing, soooo helpful!!
Much appreciated
Thank you so much. I wonder if this is possible in macOS.
much helpfull thank you
You are a Godsend!
Thank you so much 🥰🥰
Great, you're a life saver
thank you so much for this very informative video.
@AjayAnandXLnCAD
3 жыл бұрын
You are so welcome!
Thank you so much dude. God bless.
Thanks
Great video Many thanks ♥
@AjayAnandXLnCAD
3 жыл бұрын
Glad you enjoyed it
good trick, thank you sir!
Your Amazing bro... Thanks a lot saves time
Thank you
Amazing.. thank you!! you saved to me a lot of time
Great, So Amazing!!!
Fantastic. Thanks
Ultimate method.
So nice thanks you
thank you very much
Your video has to saved my entired time of work.
Owh great, this is what i am looking for, many thanks
Thank you so much you saved my day
Its so cool...many thanks
@AjayAnandXLnCAD
4 жыл бұрын
Glad you like it!
Love you bro you save my lots of time thank you so much
Done, thanks so mutchhhhh
I like this trick ,because by using this trick ,I saved my too much of time , Thanks ajay anand sir
@AjayAnandXLnCAD
4 жыл бұрын
Always welcome
😎cool man thanks for sharing
@AjayAnandXLnCAD
3 жыл бұрын
My pleasure :)
easy to understand super trick
I fell like a IT jedi now. Thanks!
Thanks Ajay…
Love you brother
Super easy to understand! Thankyou! You just save me from making 400+ folders manually😀😀😀
@Alien_Xperience
Жыл бұрын
i have a app for this if you want
Thank you very much
Thank you Thank you Thank you!!!
Wow nice tutorial, thank you sir your support and I have request same like how can rename multiple photos with different different names please make one video Thanks
Can you pls do the video combination excel and folders bulk create Like first folder then inside excel file
Superb sir
Hey, I Loved what you did? can it be done with the dates as well. for example: if i have to make a folder of month with exactly 30 dates in it. like i make folders from 01/11/2022 t0 30/11/2022 . can it be applied on the dates as well or its just for the text
@marko_markovic
Жыл бұрын
Yes, i modified it for date folders, so for 2023, this is text you need to copy to notepad and save as .bat file MD "2023_01/2023_01_01" "2023_01/2023_01_02" "2023_01/2023_01_03" "2023_01/2023_01_04" "2023_01/2023_01_05" "2023_01/2023_01_06" "2023_01/2023_01_07" "2023_01/2023_01_08" "2023_01/2023_01_09" "2023_01/2023_01_10" "2023_01/2023_01_11" "2023_01/2023_01_12" "2023_01/2023_01_13" "2023_01/2023_01_14" "2023_01/2023_01_15" "2023_01/2023_01_16" "2023_01/2023_01_17" "2023_01/2023_01_18" "2023_01/2023_01_19" "2023_01/2023_01_20" "2023_01/2023_01_21" "2023_01/2023_01_22" "2023_01/2023_01_23" "2023_01/2023_01_24" "2023_01/2023_01_25" "2023_01/2023_01_26" "2023_01/2023_01_27" "2023_01/2023_01_28" "2023_01/2023_01_29" "2023_01/2023_01_30" "2023_01/2023_01_31" MD "2023_02/2023_02_01" "2023_02/2023_02_02" "2023_02/2023_02_03" "2023_02/2023_02_04" "2023_02/2023_02_05" "2023_02/2023_02_06" "2023_02/2023_02_07" "2023_02/2023_02_08" "2023_02/2023_02_09" "2023_02/2023_02_10" "2023_02/2023_02_11" "2023_02/2023_02_12" "2023_02/2023_02_13" "2023_02/2023_02_14" "2023_02/2023_02_15" "2023_02/2023_02_16" "2023_02/2023_02_17" "2023_02/2023_02_18" "2023_02/2023_02_19" "2023_02/2023_02_20" "2023_02/2023_02_21" "2023_02/2023_02_22" "2023_02/2023_02_23" "2023_02/2023_02_24" "2023_02/2023_02_25" "2023_02/2023_02_26" "2023_02/2023_02_27" "2023_02/2023_02_28" "2023_02/2023_02_29" "2023_02/2023_02_30" "2023_02/2023_02_31" MD "2023_03/2023_03_01" "2023_03/2023_03_02" "2023_03/2023_03_03" "2023_03/2023_03_04" "2023_03/2023_03_05" "2023_03/2023_03_06" "2023_03/2023_03_07" "2023_03/2023_03_08" "2023_03/2023_03_09" "2023_03/2023_03_10" "2023_03/2023_03_11" "2023_03/2023_03_12" "2023_03/2023_03_13" "2023_03/2023_03_14" "2023_03/2023_03_15" "2023_03/2023_03_16" "2023_03/2023_03_17" "2023_03/2023_03_18" "2023_03/2023_03_19" "2023_03/2023_03_20" "2023_03/2023_03_21" "2023_03/2023_03_22" "2023_03/2023_03_23" "2023_03/2023_03_24" "2023_03/2023_03_25" "2023_03/2023_03_26" "2023_03/2023_03_27" "2023_03/2023_03_28" "2023_03/2023_03_29" "2023_03/2023_03_30" "2023_03/2023_03_31" MD "2023_04/2023_04_01" "2023_04/2023_04_02" "2023_04/2023_04_03" "2023_04/2023_04_04" "2023_04/2023_04_05" "2023_04/2023_04_06" "2023_04/2023_04_07" "2023_04/2023_04_08" "2023_04/2023_04_09" "2023_04/2023_04_10" "2023_04/2023_04_11" "2023_04/2023_04_12" "2023_04/2023_04_13" "2023_04/2023_04_14" "2023_04/2023_04_15" "2023_04/2023_04_16" "2023_04/2023_04_17" "2023_04/2023_04_18" "2023_04/2023_04_19" "2023_04/2023_04_20" "2023_04/2023_04_21" "2023_04/2023_04_22" "2023_04/2023_04_23" "2023_04/2023_04_24" "2023_04/2023_04_25" "2023_04/2023_04_26" "2023_04/2023_04_27" "2023_04/2023_04_28" "2023_04/2023_04_29" "2023_04/2023_04_30" "2023_04/2023_04_31" MD "2023_05/2023_05_01" "2023_05/2023_05_02" "2023_05/2023_05_03" "2023_05/2023_05_04" "2023_05/2023_05_05" "2023_05/2023_05_06" "2023_05/2023_05_07" "2023_05/2023_05_08" "2023_05/2023_05_09" "2023_05/2023_05_10" "2023_05/2023_05_11" "2023_05/2023_05_12" "2023_05/2023_05_13" "2023_05/2023_05_14" "2023_05/2023_05_15" "2023_05/2023_05_16" "2023_05/2023_05_17" "2023_05/2023_05_18" "2023_05/2023_05_19" "2023_05/2023_05_20" "2023_05/2023_05_21" "2023_05/2023_05_22" "2023_05/2023_05_23" "2023_05/2023_05_24" "2023_05/2023_05_25" "2023_05/2023_05_26" "2023_05/2023_05_27" "2023_05/2023_05_28" "2023_05/2023_05_29" "2023_05/2023_05_30" "2023_05/2023_05_31" MD "2023_06/2023_06_01" "2023_06/2023_06_02" "2023_06/2023_06_03" "2023_06/2023_06_04" "2023_06/2023_06_05" "2023_06/2023_06_06" "2023_06/2023_06_07" "2023_06/2023_06_08" "2023_06/2023_06_09" "2023_06/2023_06_10" "2023_06/2023_06_11" "2023_06/2023_06_12" "2023_06/2023_06_13" "2023_06/2023_06_14" "2023_06/2023_06_15" "2023_06/2023_06_16" "2023_06/2023_06_17" "2023_06/2023_06_18" "2023_06/2023_06_19" "2023_06/2023_06_20" "2023_06/2023_06_21" "2023_06/2023_06_22" "2023_06/2023_06_23" "2023_06/2023_06_24" "2023_06/2023_06_25" "2023_06/2023_06_26" "2023_06/2023_06_27" "2023_06/2023_06_28" "2023_06/2023_06_29" "2023_06/2023_06_30" "2023_06/2023_06_31" MD "2023_07/2023_07_01" "2023_07/2023_07_02" "2023_07/2023_07_03" "2023_07/2023_07_04" "2023_07/2023_07_05" "2023_07/2023_07_06" "2023_07/2023_07_07" "2023_07/2023_07_08" "2023_07/2023_07_09" "2023_07/2023_07_10" "2023_07/2023_07_11" "2023_07/2023_07_12" "2023_07/2023_07_13" "2023_07/2023_07_14" "2023_07/2023_07_15" "2023_07/2023_07_16" "2023_07/2023_07_17" "2023_07/2023_07_18" "2023_07/2023_07_19" "2023_07/2023_07_20" "2023_07/2023_07_21" "2023_07/2023_07_22" "2023_07/2023_07_23" "2023_07/2023_07_24" "2023_07/2023_07_25" "2023_07/2023_07_26" "2023_07/2023_07_27" "2023_07/2023_07_28" "2023_07/2023_07_29" "2023_07/2023_07_30" "2023_07/2023_07_31" MD "2023_08/2023_08_01" "2023_08/2023_08_02" "2023_08/2023_08_03" "2023_08/2023_08_04" "2023_08/2023_08_05" "2023_08/2023_08_06" "2023_08/2023_08_07" "2023_08/2023_08_08" "2023_08/2023_08_09" "2023_08/2023_08_10" "2023_08/2023_08_11" "2023_08/2023_08_12" "2023_08/2023_08_13" "2023_08/2023_08_14" "2023_08/2023_08_15" "2023_08/2023_08_16" "2023_08/2023_08_17" "2023_08/2023_08_18" "2023_08/2023_08_19" "2023_08/2023_08_20" "2023_08/2023_08_21" "2023_08/2023_08_22" "2023_08/2023_08_23" "2023_08/2023_08_24" "2023_08/2023_08_25" "2023_08/2023_08_26" "2023_08/2023_08_27" "2023_08/2023_08_28" "2023_08/2023_08_29" "2023_08/2023_08_30" "2023_08/2023_08_31" MD "2023_09/2023_09_01" "2023_09/2023_09_02" "2023_09/2023_09_03" "2023_09/2023_09_04" "2023_09/2023_09_05" "2023_09/2023_09_06" "2023_09/2023_09_07" "2023_09/2023_09_08" "2023_09/2023_09_09" "2023_09/2023_09_10" "2023_09/2023_09_11" "2023_09/2023_09_12" "2023_09/2023_09_13" "2023_09/2023_09_14" "2023_09/2023_09_15" "2023_09/2023_09_16" "2023_09/2023_09_17" "2023_09/2023_09_18" "2023_09/2023_09_19" "2023_09/2023_09_20" "2023_09/2023_09_21" "2023_09/2023_09_22" "2023_09/2023_09_23" "2023_09/2023_09_24" "2023_09/2023_09_25" "2023_09/2023_09_26" "2023_09/2023_09_27" "2023_09/2023_09_28" "2023_09/2023_09_29" "2023_09/2023_09_30" "2023_09/2023_09_31" MD "2023_10/2023_10_01" "2023_10/2023_10_02" "2023_10/2023_10_03" "2023_10/2023_10_04" "2023_10/2023_10_05" "2023_10/2023_10_06" "2023_10/2023_10_07" "2023_10/2023_10_08" "2023_10/2023_10_09" "2023_10/2023_10_10" "2023_10/2023_10_11" "2023_10/2023_10_12" "2023_10/2023_10_13" "2023_10/2023_10_14" "2023_10/2023_10_15" "2023_10/2023_10_16" "2023_10/2023_10_17" "2023_10/2023_10_18" "2023_10/2023_10_19" "2023_10/2023_10_20" "2023_10/2023_10_21" "2023_10/2023_10_22" "2023_10/2023_10_23" "2023_10/2023_10_24" "2023_10/2023_10_25" "2023_10/2023_10_26" "2023_10/2023_10_27" "2023_10/2023_10_28" "2023_10/2023_10_29" "2023_10/2023_10_30" "2023_10/2023_10_31" MD "2023_11/2023_11_01" "2023_11/2023_11_02" "2023_11/2023_11_03" "2023_11/2023_11_04" "2023_11/2023_11_05" "2023_11/2023_11_06" "2023_11/2023_11_07" "2023_11/2023_11_08" "2023_11/2023_11_09" "2023_11/2023_11_10" "2023_11/2023_11_11" "2023_11/2023_11_12" "2023_11/2023_11_13" "2023_11/2023_11_14" "2023_11/2023_11_15" "2023_11/2023_11_16" "2023_11/2023_11_17" "2023_11/2023_11_18" "2023_11/2023_11_19" "2023_11/2023_11_20" "2023_11/2023_11_21" "2023_11/2023_11_22" "2023_11/2023_11_23" "2023_11/2023_11_24" "2023_11/2023_11_25" "2023_11/2023_11_26" "2023_11/2023_11_27" "2023_11/2023_11_28" "2023_11/2023_11_29" "2023_11/2023_11_30" "2023_11/2023_11_31" MD "2023_12/2023_12_01" "2023_12/2023_12_02" "2023_12/2023_12_03" "2023_12/2023_12_04" "2023_12/2023_12_05" "2023_12/2023_12_06" "2023_12/2023_12_07" "2023_12/2023_12_08" "2023_12/2023_12_09" "2023_12/2023_12_10" "2023_12/2023_12_11" "2023_12/2023_12_12" "2023_12/2023_12_13" "2023_12/2023_12_14" "2023_12/2023_12_15" "2023_12/2023_12_16" "2023_12/2023_12_17" "2023_12/2023_12_18" "2023_12/2023_12_19" "2023_12/2023_12_20" "2023_12/2023_12_21" "2023_12/2023_12_22" "2023_12/2023_12_23" "2023_12/2023_12_24" "2023_12/2023_12_25" "2023_12/2023_12_26" "2023_12/2023_12_27" "2023_12/2023_12_28" "2023_12/2023_12_29" "2023_12/2023_12_30" "2023_12/2023_12_31"
very informative
@AjayAnandXLnCAD
3 жыл бұрын
Glad it was helpful!
what if I wanted to add information that aligned with each folder but in a separate column - I've synced a sharepoint documents section and used this to create client folders
Terrific ...
Informative bro
@AjayAnandXLnCAD
4 жыл бұрын
Thanks bro 😊
great brooh
Nice vedio sir folders created with this coding now sir i want to know if i want to move the pdf file with same name which i have given to the folder how i can move different pdf files in diffrent folders with one click
please share videos of how to create a dashboard with graphs and other functionalities.
Please help. I want to create multiple Excel workbook in same folder by VBA.
Legend
Super
Hi thanks for sharing this video. i tried this one unfortunately after renaming to bat file folder is not created
@AjayAnandXLnCAD
4 жыл бұрын
Please check whether the File name extensions are visible or not. You can find this option in the View tab (Windows 10). Mark the checkbox file extension and try again.