I tried identifying the previous row and comparing the current row to the previous row but that doesn't always work because I can have multiple subfolders at one level before moving to the next level.Īs we close the first year of the Microsoft Power Up Program, it’s time to pause, reflect, and celebrate the milestones achieved on this incredible journey. The file paths of this scenario would look like this: So 1.1, 1.2, and 1.3 are all subfolders of 1. The folder name should be what is in the 'Index' column, followed by an underscore, followed by what is in the 'Title' column. A folder is below another folder based on the 'FolderLevel' column. The logic is essentially, within each fileroom, there are folders and subsequent subfolders. I have attached a screenshot (because I didn't see where I could attach a file below). There is a folder structure has logic to it, it is just multi-faceted so I'm struggling to implement for each loops and if statements to do this. ![]() I am trying to create a folder structure based on an excel template.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |