I am a self-taught "NOOB" Code is barely understandable, I have searched for the solution and i have found many that will do what i want, but the code i have found has more features than i need and i do not know how to edit. I have a project tracking sheet with links to the folder i am working on. ex: =HYPERLINK("E:\Users\Corp Est\LM Region\PROJECTS\"&D18&+" - "&+C18,"GO TO FOLDER") or E:\Users\Corp Est\LM Region\PROJECTS\PORT NEAL CONCRETE UNIT 4 - LM-IA1144-C. I manually create these folders, but i'd like to have a macro that creates them for me. I'd also like to be able to create 2 sub-folders: "BOL" and "Tonnage"
I have a cell that adds the value of several cells to create a folder location:
(column F)
="E:\Users\Corp Est\LM Region\PROJECTS\"&D15&+" - "&+C15 or
E:\Users\Corp Est\LM Region\PROJECTS\PORT NEAL CONCRETE UNIT 4 - LM-IA1144-C
the folder "E:\Users\Corp Est\LM Region\PROJECTS\" exists, I want to add folders as i add projects to my list
I want to press a button than will search through column E and create a folder for the values it finds unless
it already exists.
Thanks!
Bookmarks