Adding information to Directory Creating Macro

[kripat-96]

Hi, I currently have a macro which creates folders based on a selection, and then hyperlinks them appropriately, - credit to ExcelSpreadsheetsHelp. The data I create the folders from exists in Column A. I would like to edit the macro, to also add data from Column D. For example, if the text in Column A is "001" and the text in Column D is "Project 1", I would like the directory to be named as "001 - Project 1". Can anybody help with this? I've attached a sample file and the code. Kind Regards

Please Login or Register  to view this content.

[BadlySpelledBuoy]

One quick and easy way....
Change this section:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

BSB

[kripat-96]

Awesome, Thank you! I also had to change the line of code which the hyperlinks referred to, but it works great.

[BadlySpelledBuoy]

Happy to help.
Thanks for the rep

BSB