Dynamic Hyperlink

[KennyJayyy]

Hello,

I'm trying to create a dynamic hyperlink based off a cell value.
I have numerous worksheets within this workbook in numerical order starting at "001" and ending at "100". Each Tab is a project.

I want to be able to type in value, such as "001" in C6, in column C that will automatically hyperlink to worksheet "001" and so on.
See below:

v/r
Kenny

 

[Fluff]

If you have a hyperlink pointing to another sheet, when you click it you will be taken to that sheet.

 

[My Aswer Is This]

If you have a hyperlink pointing to another sheet, when you click it you will be taken to that sheet

Using your example shows me the value in the cell but when I click on the cell does not take me to the cell.
I have used Hyperlinks before but never the way you provide. Using Excel 2013

 

[Fluff]

With the formula in post#3 if you put a valid sheet name in C6 then when you click on the formula cell it should take you to A1 on whatever sheet is in C6

 

[My Aswer Is This]

With the formula in post#3 if you put a valid sheet name in C6 then when you click on the formula cell it should take you to A1 on whatever sheet is in C6

OK. Been using Excel for a long time and now feel stupid I could not understand this.
I now have it working

 

[Fluff]

Glad it's working & thanks for the feedback.