Create hyperlink for each folder and particular sub folder

[Hesk]

Hello,

Thank you for looking at my problem, is there a way to fill series a hyperlink for each folder? the attached image show how i currently do it but this is time consuming as i have to go into each folder and copy the link from explorer.

And further more the end number i also have to change manually.Untitled.png

[moxb]

I have created .xlsm file with a macro that will do what you need.
There is a button "Insert Hyperlinks" that opens a folder list to select, and then populate column A with all the hyperlinks for the subfolders of selected folder.
Please try, and if you need further help, I will be glad to assist you.

[Hesk]

Good Afternoon moxb,

We trust this message finds you well.

Thank you for your help, two things:

1. Is there a way to direct the hyperlink to a sub folder? for example the hyperlink will take me to the top level of the folder eg =HYPERLINK("Z:\Contracts\FRC40346 - McFadden - Widnes - Greggs Drive Thru")
, but within this folder there is a sub folder called "Cost Card", that is where i would like the hyperlink directed too.

2. could you shoten the name of the hyperlink, presntly is comes up as eg "Z:\Contracts\FRC40346 - McFadden - Widnes - Greggs Drive Thru", could this just read "FRC40346"??

Again,thank you so much for your help. eg.png

[moxb]

OK, try it now.

[Hesk]

Good Afternnon moxb, the formula seems to create a hyperlink for every folder and sub folder, im looking for a link to a particular folder called "Cost Card"

Attachment 826861