Hi All,

I am trying to create a new folder within a directory based on the value within a cell however I cant figure out how to change the folder path once the cell value changes.

I am using the MkDir function to create the folder.

If I have 3 main folders: C:\Sound Testing C:\Air Testing C:\Environmental

If I select Sound Testing from my drop down list and enter the test details for Test No.X I then want to create a folder C:\Sound Testing\TestX

I guess its some sort of 'IF' statement which returns the filepath but not sure how to implement it.

Any help appreciated