+ Reply to Thread
Results 1 to 3 of 3

Macro- Hyperlink from cell value to tab

  1. #1
    Registered User
    Join Date
    11-20-2010
    Location
    nowhere
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Macro- Hyperlink from cell value to tab

    Hello,

    I have a list of values (approx. 250 customer names, A2:A250).
    Through another macro I found online, I created a tab for every single one of these customers (for further information and details). The tabs and values in the cells are exactly the same.

    I have no idea about how to program VBA or any other language.
    What I am trying to do is to get a hyperlink from the customer name to the corresponding tab.
    Any chance someone could help, please?

    Much obliged,

    Lobo123

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro- Hyperlink from cell value to tab

    CREATE SHEETS
    Here's a macro for creating an ordered set of sheets based on a column of strings AND add clickable hyperlinks in an adjacent column, basically a linkable index sheet. There's a sample sheet to try it on:
    Create Sheets

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,647

    Re: Macro- Hyperlink from cell value to tab

    You've got already one:
    go to the navigation buttons in the window's left down corner: click the rightmouse: et voilą



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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