Making A Hyperlink in a Cell

Hi all,


I am making a Human Resource Pay Roll in MS EXCELL 2013,

I want a Drop Down List of all the Employees ID's in it and when I select one ID from that list it should go to the corresponding Employees Time Sheet which is prepared on the same work book but on different sheet

This example creates a hyperlink
To: cell A1
On: the sheet named MySheet
In: the current workbook

A1: The hyperlink text to display: Click Me
B1: The sheet to link: MySheet

This formula creates the hyperlink
C1: =HYPERLINK("#'"&B1&"'!A1",A1)

Note the hash mark (#) before the sheet name
(The apostrophes would be needed whenever the sheet name contains spaces)

Now, when you click on cell C1...you will go to cell A1 on the sheet named MySheet

Is that something you can work with?

Right Click on the cell --> Select "Hyperlink" --> Then make your way to the file you want to link to the employee name and double click the file name. If you're using something based on data validation you will need to create the hyperlink on the lookup tab.

The DV list won't be a hyperlink.
If you want that functionality you will need to use a macro. If that would be the only VBA code in the workbook, you may just want to instruct users to select a name from the list...then click the hyperlink next to the selection cell.

Does that help?