Open the workbook and select the range of cells that you want to use.Ģ. Put the active workbook into a specific directory which you will place the created folders into. Quickly create folders based on cell values with Kutools for Excelįor example, I have a range of names in a worksheet, I want to create folders for each of them, and save them to a specified path, with the VBA code, I can finish this task.ġ. But how could you quickly create these folders? Today, I will introduce you some quick tricks:Ĭreate folders based on cell values with VBA code If you create the folders one by one, it will waste a lot of time. Supposing you have a list of staff names in a range of a worksheet, and now you want to create some folders for each of them in the cells to record their information. How to quickly create folders based on cell values in Excel?
