I’m looking for a way to accomplish the following with VBA. After entering a project name in an input box enter that name in cell A2. Next project created to be in A3, A4 and so on. For each project created copy a “template” folder with all sub folders and files into the master project folder and create a hyperlink from project name in excel to the project folder. Also each project folder copied over will contain many sub folders. I would like to create hyperlinks to 4 of those folders. So Cell B2 to subfolder 1 cell C2 to subfolder 2 cell D2 to subfolder 3 and cell E2 to subfolder 4. I know I will need to know exact file path for the folders and exact folder names. If this is possible I should be able to tweak the good to my specific needs if someone could provide me an example.