folder hierarchy

  1. L

    Macro to create folders in various locations based on cell values

    Hi All Real excel novice here! I need a macro to create folders based on a cell value (A4:A10), this value is the "job reference". This folder needs to be created in locations based on other values within the spreadsheet. These values are: Region (EU or Non-EU) Country (China, France...
  2. srizki

    Folder Open

    I am processing data, and save it as a new file each time in a folder called Aging 2013. The problem is that I have to open root dirctory each time for saving file and then I click many folders to get to this Aging 2013 folder. Is there a way to open this folder directly. This will save me a lot...
  3. J

    Returning Path of Files

    Hi, I have over 15,000 files on a file share. I am looking to try and extract the path for each individual one and paste it in a long list on a sheet with its associated folder. I'm having a hard time of where to start. the most difficult part is there are thousands of folders and different...
  4. S

    Copy files from one folder hierarchy to an other

    I need to copy all files from one folder hierarchy to an other. An example: My source is in 'c:\1' which has a number of subfolders, some of which have subfolders, etc. Along the lines of: c:\1 c:\1\a c:\1\b c:\1\b\1 c:\1\c c:\1\c\1 ... All files have to be copied to 'c:\2' and go to the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top