+ Reply to Thread
Results 1 to 1 of 1

Hyperlink to a Variable Sheet name

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    4

    Hyperlink to a Variable Sheet name

    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.
    Last edited by Gecks; 02-13-2012 at 06:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1