I need to generate folders containing certain Excel field entries:
Additionally, I need to append a date to the folder name based on that entry
So If I have the above Excel table, I'd need the following set of folders to be generated in the same directory:
Is this possible using a macro? Also, in case I add another entry how would I generate another folder only for that entry; for example I add another project CWO-1106:
Basically, I'd like to keep updating the Excel sheet and create folders only for the new entries
Any help would be appreciated. Thanks!