+ Reply to Thread
Results 1 to 2 of 2

Hyperlink to always reference current sheet

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    57

    Hyperlink to always reference current sheet

    I am trying to use the excel hyperlinks to reference a specific cell on my sheet. That is easy. The problem is I want to be able to duplicate my sheet, and have those new hyperlinks reference to the new sheet (which they are on)

    Say Sheet 1 has a hyperlink which points to: Sheet1!A100

    Now I copy everything from Sheet 1 into Sheet 2, including the hyperlink. I want it to automatically point to: Sheet2!A100

    Or in other words I want my hyperlink to somehow be written as: CurrentSheet!A100

    Thanks

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Hyperlink to always reference current sheet

    Hi,

    Just use hyperlink() function like this :

    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ 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. Replies: 8
    Last Post: 07-26-2013, 06:29 PM
  2. [SOLVED] Problem in Hyperlink - Reference to a cell of another sheet
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 12:11 AM
  3. [SOLVED] Reference of Previous sheet in current sheet cell.
    By ranjeet.bhagat57 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2012, 11:37 AM
  4. Changing reference sheet based on current quarter?
    By GarnetBlack32 in forum Excel General
    Replies: 2
    Last Post: 02-05-2012, 05:19 PM
  5. Reference different sheet for hyperlink
    By evant8950 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-31-2008, 11:55 AM

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