Hyperlinks using text from another cell

[Esteele347]

I have created 500 separate sheets based off a list that I created: IT001 - IT500. The names of the sheets are all listed in a single column (C). I need to create a hyperlink to jump to the correct sheet based upon the name of the sheet that is stored in the cell (Column C or B). I don't want to go through the task of Right-Clicking, Link, Scroll to the correct sheet, and click on it... 500 separate times.

Thanks for any suggestions.

-eric

 

[Momentman]

USE a hyperlink function instead, like this maybe in Column D/E

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

, assuming your data starts from Row 3, and you can drag it down. Surely you can select the entire cells in column C and use the hyperlink to create it at once, but you would notice that only the first cell has the hyperlink format while the others look like plain text, but the links are behind

 

[Esteele347]

Unfortunately no. I can use the hyperlink formula to create one correct cell based upon the sheet name by manually typing it, but it won't drag and fill. Still left with the same scenario.

 

[Esteele347]

USE a hyperlink function instead, like this maybe in Column D/E

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

, assuming your data starts from Row 3, and you can drag it down. Surely you can select the entire cells in column C and use the hyperlink to create it at once, but you would notice that only the first cell has the hyperlink format while the others look like plain text, but the links are behind

I tried typing in the code you provided (thank you), but it gives me a #name? error.

Suggestions?

 

[Esteele347]

USE a hyperlink function instead, like this maybe in Column D/E

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

, assuming your data starts from Row 3, and you can drag it down. Surely you can select the entire cells in column C and use the hyperlink to create it at once, but you would notice that only the first cell has the hyperlink format while the others look like plain text, but the links are behind

Nevermind... I am an idiot. Can't type this morning. That worked.

Thank you!!

 

[Momentman]

Nevermind... I am an idiot. Can't type this morning. That worked.

Thank you!!

Glad to help