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

 

[My Aswer Is This]

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:
View attachment 35241

View attachment 35240

v/r
Kenny

When you say:
Your quote:
that will automatically hyperlink to worksheet "001" and so on.
Do you mean if you enter 001 In Range("C6") the sheet named 001 will be activated.
How about we use Vba to do that. Is that a option your satisfied with

 

[Fluff]

You could put this formula in another column

=HYPERLINK("#'"&C6&"'!a1",C6)

otherwise you will need VBA

 

[KennyJayyy]

When you say:
Your quote:
that will automatically hyperlink to worksheet "001" and so on.
Do you mean if you enter 001 In Range("C6") the sheet named 001 will be activated.
How about we use Vba to do that. Is that a option your satisfied with

For clarity, when I enter 001 in "C6", cell "C6" will automatically be hyperlinked to worksheet "001". And yes sir, I'm good with using a VBA option

Thank you!!

v/r
Kenny

 

[My Aswer Is This]

My question was:
Do you mean if you enter 001 In Range("C6") the sheet named 001 will be activated.
You said:
For clarity, when I enter 001 in "C6", cell "C6" will automatically be hyperlinked to worksheet "001".

I do not know what "hyperlinked to" means
But maybe Fluff post works for you.

 

[Fluff]

I do not know what "hyperlinked to means"

It means the OP wants a hyperlink in the cell

 

[My Aswer Is This]

It means the OP wants a hyperlink in the cell

You could put this formula in another column

=HYPERLINK("#'"&C6&"'!a1",C6)

otherwise you will need VBA

I understand now.

 

[KennyJayyy]

Thank you! I used the formula Fluff posted and it will work for what I need.
Ya'll are the best!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[My Aswer Is This]

Glad we could help & thanks for the feedback.

I'm still trying to learn something here myself. Why use the above Hyperlink?
Why not just use a formula like =C6