+ Reply to Thread
Results 1 to 4 of 4

VBA Create List of tabs with hyperlingin summary tab

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Perth,Australia
    MS-Off Ver
    Office 2013
    Posts
    2

    VBA Create List of tabs with hyperlingin summary tab

    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.
    Last edited by JGUSE; 05-18-2017 at 09:13 PM.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA Create List of tabs with hyperlingin summary tab

    Hi
    try this

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA Create List of tabs with hyperlingin summary tab

    ah, I see that the file names might cause a problem with some hyperlinks. This version should fix it.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-18-2017
    Location
    Perth,Australia
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: VBA Create List of tabs with hyperlingin summary tab

    The first one works provided i dont have a "-" in the tab name

    second seems to work fine

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. collating multiple tabs within same workbook to create a master/summary tab
    By xotrujillo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2016, 05:15 PM
  2. How to create a summary of macro created tabs
    By jklovensky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2016, 02:48 PM
  3. Create a summary sheet which merges records from other tabs
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-20-2016, 05:03 AM
  4. Need Macro to create seperate tabs and summary
    By houstonking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2014, 03:53 PM
  5. Replies: 1
    Last Post: 05-18-2014, 02:12 PM
  6. Replies: 4
    Last Post: 05-02-2013, 04:39 PM
  7. List Summary from Series of Tabs
    By macky1730 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2010, 03:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1