I curerntly have a workbook that has a Summary Dashboard as a Sheet and then I have 20 sheets that are dedicated to an employee within a department. Currently I have the dashboard to read off the sheets. However, on the SUmmary page I have a field for Employee Name and this will populate the name given to a specific tab in the work book. I achieve this through the formula below:
=MID(CELL("filename",EmployeeChkLst1!$A$1),FIND("]",CELL("filename",EmployeeChkLst1!$A$1))+1,255)
This works well, but in addition to it pulling in the name of another sheet, I also want it to be a Hyperlink, which will navigate the user directly to the sheet of that employee. Can I add something to my current forumala to achieve this? The sheet names may change over time, So I need the hyperlink reference to be variable.
Any help will be greatly appreciated.
Bookmarks