lets create some folders.

turtlemann

New Member
Joined
Dec 9, 2011
Messages
4
Okay so I have a workbook where we log jobs and due dates for quotes and some other information. We keep all of our the information out on our server Organized based on action, then job number, then department. So we would put the quote in Z:\100- Projects\1 Bids\6200s\6221 Corvel Health\Estimating

Basically, I'd like for the folder to be created and named with what we log in So when we pick the number 6221 and give it the name Corvel Health the folder is already made with sub folders in the 6200s folder.

I don't know how to do this since I don't want it to delete existing folders or change them. It'll have to check to see if the folder is already created. I assume it could check by looking if the first four digits match the the job number on the sheet?


In advance thank you for your help.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,203,491
Messages
6,055,727
Members
444,814
Latest member
AutomateDifficulty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top