Fast Tip Friday – Create Subfolders Using Excel Macro

FTF-Create-Subfolders-Using-Excel-Macro

Have you ever needed to add the same subfolder to a bunch of existing folders? For instance, let's say you have a list of folders that are named by custodian and you need to add an Exhibits subfolder to each and every custodian folder. This fast tip demonstrates how to automate the task using an Excel macro.

In a previous Fast Tip Friday, I demonstrated how to create folders using a list in Excel.

Download Sample Files

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.

    • Eliot

      Excellent! Allowed me to create literally over 5000 subfolders in a matter of minutes. 🙂

      • That is awesome feedback, Eliot. Thanks for sharing your results.

        • Eliot

          Say you have 100’s of folders and each folder has different subfolders, how could you create the folders and subfolders simultaneously? Could a macro be created, if each subfolder has subfolders, for example the following doctype_folders: complaint, discovery, motions, and orders?

          Diagram below of the first three folders:

          1sub1doctype_folders
          1sub2doctype_folders
          1sub3doctype_folders
          2sub4doctype_folders
          2sub5doctype_folders
          3sub6doctype_folders