How to create folders based on cell value in excel | create Multiple folders from a list
How to create folders based on cell value in excel | create Multiple folders from a list
In this advanced excel tutorial i will show you how you can create folders from a list in excel. Let me clear the situation. Suppose i have a data list where i have names of twelve months. I need to create 12 new folders each containing names from the list. Should i do it manually? No. We will do it automatically because there could be a list of hundred names in future.
So we are about to automate this process and create new folders using the names from the list inside our excel files. Lets get started.
Step 1: Select the data range or cell values from where you need to create folders.
Step 2: Click on the Developer Tab.
Step 3: Click on Visual Basic
Step 4: Click "Insert" and then "Module"
Step 5: Write the code
after that Link your code to a button and use it to create multiple folders
Please like, Comment, Share and Subscribe our YouTube Channel Educational Revolution
Email: [email protected]
My Website Link:
Educationalrevolution786.blogspot.com
Ms Excel Shorts Playlist:
• Playlist
Convert PDf to MS-word,Excel,Powerpoint:
• Convert PDF to Excel - How to convert pdf ...
Edit Pdf File no Need to Purchase software:
• How To Edit Pdf file 2 Method ~ No Need to...
Shirk Your 10 MB File into 1 MB:
• Shrink Excel file size without internet
Subscribe Us:
/ @educationalrevolution
Facebook Page link:
/ educationalrevolution786
Facebook Group Link:
/ 440078226833339