Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink using a variable destination
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula: Add rows/lines to destination in Hyperlink | Excel Discussion (Misc queries) | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
Change Hyperlink Destination Folder | Excel Discussion (Misc queries) | |||
jump to hyperlink, extract value at specific destination in file | Excel Worksheet Functions |