+ Reply to Thread
Results 1 to 1 of 1

Auto create hyperlink in column A to numbered worksheet of corresponding row number

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2013 Home
    Posts
    10

    Auto create hyperlink in column A to numbered worksheet of corresponding row number

    My workbook has several numbered worksheets Home,2,3,4,5,6,7,8,9,...
    In the Home worksheet, column A contains various names
    I want to be able to click on any name and be taken to a worksheet with the corresponding row number.

    For example, in A40 of Home worksheet, I have Angela. I want to be able to click on Angela and be taken to worksheet "40".
    Also, If I type a new name in A41 of "Home" worksheet, the name automatically becomes a hyperlink for worksheet "41"

    The solution will likely be in Visual Basic. I welcome other alternative solutions
    Last edited by platinumeazy; 09-14-2017 at 09:28 AM.

+ 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. [SOLVED] Combine 3 Different Numbered Cells In Row To Create One Number
    By jdrenken7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2017, 02:45 AM
  2. [SOLVED] Macros to Create New Sheet, Rename, and Create HyperLink to New Worksheet
    By jacksum in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2015, 12:44 PM
  3. Replies: 5
    Last Post: 07-20-2012, 05:05 AM
  4. Auto Create Hyperlink and move to another workbook
    By Ninjai in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2010, 03:16 AM
  5. [SOLVED] HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS?
    By CARA in forum Excel General
    Replies: 1
    Last Post: 04-14-2006, 01:10 PM
  6. My worksheet is numbered in both row and column. Is that right?
    By Sheila in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 03:16 PM
  7. RE: My worksheet is numbered in both row and column. Is that right?
    By Sloth in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-21-2006, 02:45 PM

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