Hyperlink Macro that converts a list of sheet names to hyperlinks to the sheets
Hey,
I am having trouble getting a macro to do what I want.
In column A i have a list of the sheet names in the workbook
I need a macro that will take the text from the cell and convert it to a hyperlink to its corresponding sheet
for example in cell A1 there is the text "SP5M"
there is also a sheet named "SP5M"
I want a macro to take the text from the cell that I have selected, tack on the "!A1" so it becomes an address for the sheet and create a hyperlink that displays just the original name...
if that makes sense?
Solution to "Create Index page with hyperlinks to worksheets"
Of course it makes sense. Here is a solution to your request at: http://excelexperts.com/create-index-page-hyperlinks-sheets
Hyperlink macro
Can you attach your file or upload it at dropfile.webs.com