Hello!
https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html
I am referring to this great thread posted here a while ago. Formulas work beautifully, but I would like to ask for help on how to add automatic hyperlinks to the names of sheets that appear in my table of contents? Is there a way to extend the formula
=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))
in such a way that it automatically adds a hyperlink to a particular sheet of the workbook?
Thank you very much!
https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html
I am referring to this great thread posted here a while ago. Formulas work beautifully, but I would like to ask for help on how to add automatic hyperlinks to the names of sheets that appear in my table of contents? Is there a way to extend the formula
=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))
in such a way that it automatically adds a hyperlink to a particular sheet of the workbook?
Thank you very much!
