Hyperlink Drop Down selections to separate Files

[tonyab]

(Using Excel 2010 & Windows 7)
Need to link the separate name of each of four sales reps that are in a drop down menu in Excel 2010 to their individual folders on a Data (E shared drive (The Sales Rep's individual folders contain the counties assigned to each of them and they need to have quick access). I currently have each Sales Rep's name in the drop down menu originating from a global template on a page within the same form. Not sure the easiest way to do.

 

[Jerry Sullivan]

Hi and Welcome to the Board,

There's a few ways to accomplish your objective. A fairly simple approach would be to use the HYPERLINK() function in a formula in an adjacent cell.

Using a DataValidation dropdown list in Cell B3, enter this formula in Cell C3:
=HYPERLINK("E:\MyPath\"&B3&"\","Open Folder for Sales Rep: " & B3)