Amended request, only need to create directories based on data in Column F only.
One directory for each cell. Hoping that uncomplicates my query.
My request:
Is it possible to create a script/macro ?? to create a Directory (Folder) based on the content of Column "F".
No longer required below:
File has been uploaded to assist. I have reduced the number of entries to 20 but in reality there is 3,500 and is expected to become larger.
For the purpose of this request, both Columns J and K are flexible in what they contain - I manually added these to show a character count in "J" and the preferred directory name in "K". The fixed data in the sheet is in Columns "A to I" only.
Amendments can be made to both/either Column "J" which shows how many characters there are, and
Column "K" which I've used as "concatenate" to create the preferred name from the fixed data in "F & G".
My request:
Is it possible to create a script/macro ?? to create a Directory (Folder) based on the content of Column "K".
If the script could prompt the user to either:
a) "Browse" to determine the file path to follow (preferred option) for creation, or
b) create in a default location of "C:/Temp/Units/" (create automatically if not already created), or
c) type it manually (non preferred option).
The option a) example would be:
Run the script/macro, a prompt would ask where do you want to place these newly created Directories (or similar abbreviated comment), then the user would selected the file path, click OK, the script would create the directories (folders) with the names as listed in Column K.
The option b) example would be:
Run the script/macro, advise that newly created Directories will be created and placed in "C:/Temp/Units/" the user clicks OK, the script would create the directories (folders) with the names as listed in Column K.
Thank you in advance if you've read the request, and a bigger thank you if you have the time to provide me with an outcome.
kindest regards
Chris
Bookmarks