How to create folders based on cell value in excel or create folders from a list.
66.6 هزار بار بازدید -
5 سال پیش
-
In this advanced excel tutorial
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 (Please subscribe and here goes the code: https://msexceltutorial.com/post/How-...)
Step 6: Now run the code and done.
You have successfully created new folders based on your list in excel.
#CreateFolder #List
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
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 (Please subscribe and here goes the code: https://msexceltutorial.com/post/How-...)
Step 6: Now run the code and done.
You have successfully created new folders based on your list in excel.
#CreateFolder #List
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
5 سال پیش
در تاریخ 1398/06/17 منتشر شده
است.
66,670
بـار بازدید شده