Thread
:
Hyperlink using a variable destination
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
external usenet poster
Posts: 5,441
Hyperlink using a variable destination
Christos,
=HYPERLINK("[Book1.xls]Sheet1!" & A1, "Click me")
Change Book1 to the workbook name, Sheet1 to the sheet name.
HTH,
Bernie
MS Excel MVP
"Christos T" <Christos
wrote in message
...
I want to have a hyperlink pointing to a different cell depending on the
value of another cell.
i.e.
Cell A1 has a variable value depending on some function, e.g. Z8 (which is
the cell address of where I want the hyperlink to be pointing to)
I want to have a hyperlink in cell D10 taking the data from cell A1 (i.e.
Z8) and pointing to cell Z8.
I don't know macro, so if I need macro to do this could someone please guide
me through it ?
Many thanks in advance
... also could you please email me the answer as well to
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick