How Do I Automatically Hyperlink To The Reference In A Cell?


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
How Do I Automatically Hyperlink To The Reference In A Cell?  Excel

View Answers


Hello,
I have searched the board and can't find the answer to this particular hyperlink question.
I want to be able to create a hyperlink in a cell that is the result of a simple reference formula. i.e. if cell A1 on worksheet A is a formula "='SheetB"!A1", can I create a hyperlink automatically from SheetA Cell A1 to 'SheetB'!A1?
I would like for the hyperlink to be is cell A1, so I beleive that would be a macro / VBA solution.
Also, is there a formula solution that could go in B1 "=hyperlink(A1)", where the formula will then recognize the referenced cell (rather that the formula result) and hyperlink to SheetB:A1?
Hope all of that is clear.
Thanks...Dean
Similar Excel Video Tutorials
HYPERLINK function & Drop Down List
 See how to use Data Validation List Dropdown and the hyperlink function to create a list of hyper links. See how to link to a web site or a cell on a ...
Cell References Relative & Absolute
 The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#8 Video topics:
1)Cell references in for ...
Similar Topics
I had a browse around the forum for an answer to my question, but without any joy. Hopefully somebody can help me out...
I'm hyperlinking within an Excel spreadsheet; from a cell in one worksheet to a cell in another. This is working fine. However, when I add/remove a row/column my hyperlinks get screwed up.
For example, I'm linking from cell A2 in SheetA to cell B2 in SheetB.
If I add a row in SheetB, the cell I'm referencing now becomes cell C2.
However, the hyperlink does not become C2; it stays as B2.
Therefore my hyperlink is referencing the wrong cell.
There must be a way to keep the links when I add/delete a row.
Any ideas?
Thanks,
Tim
Here I am again with another hyperlink problem. I think I might have a hyperlink addiction.
The formula below should lead me to a worksheet that contains the named range MAXSHEET. However, when I click on the link I get "Reference is not valid". I know the index formula is working fine, it's returning the correct result. Why can't I hyperlink to the cell that contains that result?
=HYPERLINK("#"&INDEX(MAXSHEET,3,6,1),"LINK")
Thank you in advance.
Hello everyone,
I would appreciate help with the following:
I want to have a macro follow the hyperlink in cell E5. I've tried several thinks from previous posts but the macro would select the cell rather than follow the hyperlink in it.
Details: I have the following hyperlink formula in cell E5 [=HYPERLINK($D$4)]
where $D$4 = CONCATENATE("[PM T&AS.xlsm]",C4)
[PM T&AS.xlsm] is the file name
C4 gives the cell name of the desired destination (through a formula), i.e. B7
Please note that the hyperlink is to go to a cell in the same worksheet and that the hyperlink varies according to the data given by cell C4.
Thank you in advance.
Best.
I am trying to link a hyperlink in a formula using VLOOKUP. I can get my new cell to reference the cell I want it to reference, but it will not carry the hyperlink with it. Any suggestions?
Example:
cell A2=VLOOKUP(C2,Profiles,5,FALSE)
The reference cell contains a hyperlink, but A2 will not send me to the hyperlink.
Thanks,
Chris
Hi there,
I have a column of cells with a formula in each to return a result . (about 40 rows)
I want to add a hyperlink to each one referencing an individual htm page.
The htm pages increments by one, example, page1.htm, page2.htm etc
At the minute Im right clicking each cell individually and selecting Hyperlink... and adding the name to the Address section.
I cant use =HYPERLINK because there is a formula in each one.
Is there a way to copy/paste the hyperlink to each cell and increment by 1 in the same way as adding text to the cell and drag/drop
I'm using the formula below to automatically select the hyperlink location.
=HYPERLINK("#"&VLOOKUP(G27,EXERCISE_1LU,2,FALSE),"1B")
It works great with named ranges, but I want to get crazy and have the hyperlink result be an actual web address versus a defined range name. The result I'm getting is "Reference is not Valid"
I've used both the http:// prefix and only www. prefix. Neither worked. Any help would be greatly appreciated.
Sheet 1, cell A1 has the hyperlink.
Hyperlink details are ...
Type the "cell reference" is C1.
Select a place in this document: Cell reference 2 (sheet 2).
Formula required for "cell reference". I want the C1 to change on a daily basis, to the next row without having to edit the hyperlink.
Hi everyone,
I'm trying to figure out a formula (preferably formula, if not possible, then custom VBA formula) that determines whether the current cell is a hyperlink.
For example, is there a formula that looks like this?
=IF(ISHYPERLINK(A1),"This cell is a hyperlink","This cell is not a hyperlink")
Where A1 is the cell being tested.
Please let me know! I've searched the web and the forums for this without answer
Thank you!
Hello Everyone I have a hyperlink question and cannot find a solution anywhere.
Basic problem: i cannot figure out how to use HYPERLINK to Go to a cell in the same workbook.
Sub Problem: the cell that will contain the hyperlink will be dynamic based on a lookup.
=HYPERLINK(VLOOKUP(B1,DataArray,1,FALSE), "Link" )
Is this possible?
Could it be possible to write a GOTO function to do this if it cannot be done with formulas?
Thanks!
Hello,
I need to have a solution for the following excel requirement.
Assume that C5 has "some_val".
i need to look in the whole column of A for the cell value of "some_val" and i have to create a hyperlink to the matching cell.
(Assume that A15 has "some_val", then hyperlink in C5 should link to A15 automatically)
This process has to be automated as i have about >1000 cells. Hope i'm clear with my requirement!
Looking for some formula/vb script
Thanks in advance
This HAS to be a simple fix.... Could not find a string with this solution in it yet.
Trying to set up a hyperlink to reference another location in the same sheet.
Used the example in Excel as a model to set this up so placed this formula in cell B1:
=hyperlink([Book1]Sheet1!a1,"LINK")
this defaults to =hyperlink(Sheet1!a1,"LINK") since Book1 is the current wb.
clicking on "link" in cell B1 produces "Cannot open specified file" error.
I need the hyperlink to be dynamic, so I can't use the CTRL+K hyperlink function.
Thanks in advance for any help
I recieved help with this from the Board and it was great. As with all things it posed new questions.
Now that I can change the Active Sheet name automatically I want to be able to Hyperlink it to another sheet. What I do is set a hyperlink from a "Table of Contents" page. The problem now is that if the name of the page changes, the Hyperlink reference will no loger reference the page. Is there a formula that will change as the Active sheet name changes?
ie.
Cell $C$7 will change from Last Name, First name to another Last name/ First name. This will change the Reference and the hyperlink will no longer work. Is there a way I can have the Hyperlink ALWAYS reference this page, no matter what the name change?
Thanks in advance!!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim Rng1 As Range
If Target.Address = "$C$7" Then
ActiveSheet.Name = Left(Target.Value, 12)
End Sub
I found this solution for "drop down list with hyperlink" but it did not work.
Perhaps a better solution is to use a workaround that relies on the HYPERLINK function to refer to whatever is selected in the dropdown list. For instance, if you have your data validation dropdown list in cell A1, then you might put the following formula in cell B1:
=HYPERLINK(A1, "Goto Link")
The solution directly above provides exactly what I am looking for
in the field where I write the formula, but it fails to hyperlink.
I have created a drop down list and linked each one of them to a
specific worksheet. When I select them individually they link to
appropriate worksheet. But when I select them in the drop down
list I receive the following error when I select the Hyperlink in
cell B1 as directed above.
"Cannot open the specified file"
Any thoughts?
Bob
I have an Excel document where I want to put text and a hyperlink in the same cell. . . . it appears to make all the words a hyperlink rather than just the hyperlink itself . . . do you have a solution?
ok i was wondering if this is even possible.
i want a hyperlink to reference to the contents of another cell example
REFERENCE TABLE
 A  B 
1 Alexander  Sheet1 
2  Alona  Sheet5 
3  Alfie  Sheet3 
Column A is the hyperlinks. column B is the exact name of another worksheet in this workbook. i want the hyperlink to reference to the cells in column B so when the hyperlinks are clicked the active (or visible) sheet is the sheet being referenced. example, when cell A1 (Alexander) is click it will take you to (reference B1) Sheet1. is this possible? i know i can make a simple hyperlink by right clicking and going to hyperlink and then just choose the "place in this document" but i have many many many many hyperlinks to make, i was hoping i can do it formula wise.
Greetings, I am using excel 2003 to create a pictorial directory for our church. On one worksheet I have ~200 pictures. On 13 other worksheets I have all of the addresses and such layed out. On a whim I started hyerplinking the pictures so that if you clicked on the persons picture you were taken right to their info  pretty straightforward stuff. But the thought just occured to me that if I add a new address here or there, all of the hyperlinks will need to be updated, or any of the ones after the new one anyway. I wonder if you can code the hyperlink to look for a cell value instead of a cell reference i.e. "Johnson" instead of "C4". I know that this is easy to do with the "=HYPERLINK" formula but not so sure about the object hyperlink. I looked through the message board and perused the excel help and did not really see anything. Anybody have any ideas? Thanks, RB
Hello all,
I have a formula like below with a HYPERLINK function inside an IF statement.
=IF(A3="red",HYPERLINK("http://www.google.com","GOOGLE"),"no link")
When cell A3 = red, the link works perfectly. However, when A3 does not equal red, the cell with this formula still appears as if it is a hyperlink. I get the hyperlink cursor when I hover over the cell, and when I click the cell I get an error message stating that the address of the site is not valid.
Is there any way to get rid of this error? If I write the formula like below I don't get the error, but this doesn't give me the result that I want.
=IF(A3="red",HYPERLINK("http://www.google.com","GOOGLE"),"")
Thanks,
Rick
Excel 2003
I have a series of hyperlinks in cells that display dates. I am looking for a formula that will reside in a different cell, that determines the latest (max) of these dates, and then will have a hyperlink that connects to the hyperlink of that cell.
That is, I would like to have hyperlink in a cell, and have it open the hyperlink of a different cell. The selection of that different cell is based on a determination as to whether the date displayed in that cell is the maximum value of a range of cells (each cell has different hyperlinks).
Thank you! in advance
I have a spreadsheet where I use columns a, b, & c to create a hyperlink.
Column in D2 is =hyperlink(a2&b2&".htm",c2).
This works fine. What I want is a worksheet that just has D2 in it with the associated hyperlink, so it would appear that I typed in c2, and did an insert hyperlink.
Then I would not have to have columns a, b, c. I know that I can hide those columns, but is there a way to just copy the contents of my resulting cell d to a new workbook?
Morning all
I'm trying to use a hyperlink based on a cell that has an indirect() ref to a worksheet which is named the same as the cell.
eg.
Index Sheet Cell Formula/Text
A1 Archer
B1 =INDIRECT("'"&A1&"'!A1")
C1 =HYPERLINK(B1)
now if the sheet 'Archer' Cell A1 had the text 'help' then the result of 'Index!B1 would be 'help' so I know the function is referring to the correct place in the workbook. How then do I get Index!C1 to hyperlink to Archer!A1
the reason for all this is that I want to create and navigate a workbook with 200+ tabs with an index using filters (ie. Index!ColA) then click on the result of the filter (Index!ColB) to jump to the correct tab (or use a lookup, either way is fine) so I want the hyperlink formula based so I don't have to Insert/Hyperlink each time (by the way I will be creating 4 of these so 1000 + hyperlinks).
I am addicted to the knowledge on this board...
What I currently have is a list of people that is created from references. Each person's name is also the name of a worksheet in the book. I want to take this name (output) and insert it into a hyperlink formula in the cell next to their name that would allow the user to quickly jump to their personal sheet.
I have tried this on a whim but it did not work...
=HYPERLINK("(D6)&!", (D6))
I was hoping that the value in cell D6 would be inserted and thus give me something like =HYPERLINK("Chris!", Chris) although I am not sure that is even the correct formula for linking to a worksheet.
Hi,
I'd like to create an hyperlink to the first blank (empty) row in column A of a sheet. Is it possible to use "Insert / Hyperlink" and input a formula in the "Type the cell reference" box?
If so, which formula? If not, is there another way (not using VBA), so that I can type in the hyperlink cell "Go to first blank row in column A" and actually go there by clicking in the cell?
Thanks for any help.
MrDoc
I have a path to a file in cell B10. I want cell b10 to be converted to a
hyperlink without needing to point to a different cell (which I can do with
the worksheet HYPERLINK function.
I want to do this programmatically via VB.
I have searched prior hyperlink questions and answers on this site but have
found my case.
Thanks,
Sandy
Want to know how I can combine formula
I want to hyperlink a cell that has a formula in it
Example:
have XXXXXX.com in onecell
Formula: add the www. to it to have results in another cell but it does not create a hyperlink
Using: =CONCATENATE ("www.",B1)
What do I need to make the end result a hyperlink ?
Hi,
I am trying to come up with formula to use HYPERLINK function.
IF A2="YES" THEN B2=HYPERLINK("\\c:temp\test.file")
I need cell B2 to show hyperlink based on the value of cell A2 (YES/NO).
Is this possible?
Thank you,
djanu