Hyperlink muliple items

[Steve Nichols]

Hi Again

I have 350 surnames in column A of a spread sheet.
Using some vba from this site, I have created multiple file folders with each persons name, these are located currently in the same root folder as the spreadsheet. (F:\Groundstaff\Names)

I need to find a solution to hyperlink the staff names to their respective folders all at once as hyperlinking 350 names one at a time would be a nightmare.

Can anybody help

Please

As always I am thankful for your assistance

 

[Faseeh]

This should work if you have name of folder same as that name of emplyee. Simply put the path againt against eath empolyee name with final folder name taken from the "Name" Column and use HYPERLINK() formula. See attachment.

 

[Steve Nichols]

Hi

Is there anyway of getting this to display just the name rather than the full path or the word "link"

Regards

 

[bosco_yip]

Maybe……

1] Column A is the staff name list

2] In B2, formula copy down :

=HYPERLINK("F:\Groundstaff\"&A2,A2)

Regards
Bosco