Hyperlink help

[jsambrook]

I have a spreadsheet for timesheets that has a summary page on the front and all of the employees have a tab with their time on it. I want to have a hyperlink to the employee tab on the same cell as the employee name on the summary sheet. The problem that I have is that I have a macro that inserts all the sheets for a new employee and it will copy and paste this in as the new employee so ideally the link needs to use what is in the cell. Any ideas?
thanks
Janni

 

[Andrew Poulsom]

You can construct a hyperlink with a formula like this:

=HYPERLINK("#'Employee Name'!A1","Employee Name")

Change Employee Name to the name of the worksheet.

 

[jsambrook]

Thanks for that, can I get the employee name to link to a cell with the employee name in it? Would I need to use indirect? Also what purpose does the # key have?
thanks
Janni

 

[Andrew Poulsom]

If A1 contains the employee name:

=HYPERLINK("#'"&A1&"'!A1",A1)

The # means the workbook containing the formula.