Hi All
i am trying to create a macro that creates a list of the tab names in my work book in my "Summary" tab from Cell "A3" onwards with a hyperlink back to the original tab.
I have two tabs i dont want appearing in this list, "Summary" and "template" tab.
I currently have the attached which gives me thelist i need but i cant seem to modify for the hyperlink part.
Sub tabnames()
numberOfSheets = Worksheets.Count
For i = 1 To numberOfSheets Step 1
Cells(3, 1).Offset(i - 1, 0) = Worksheets(i + 2).Name
Next i
End Sub
For example, i have the following tabs,
- Template
- Summary
- G-001
- G-003
- F-001
In the summary tab from Cell A3 onwards i want G-001 onwards to appear (i will be constantly adding sheets) i want to overwrite the current list not delete.
Bookmarks