Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auotomating Hyperlink?
Hi everyone:
Say I have a 2D matrix, or x-y matrix liks this: March April May 1 2 3 Say March, April, and May are cells in a different sheet. Now, If I highlight 2-April cell, for example, I want to be linked to "April" cell in that different sheet. And so on for other. I know how to do hyperlinking but that is NOT what I am asking. I have here what you might call "Conditional Hyperlink" that I would like to have. Is this doable? Any other way? Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auotomating Hyperlink?
Hi Mike,
A formula like this may do what you are looking for: =HYPERLINK("[Book1.xls]'" & $A2 & "'!" & B$1,"link") Change Book1.xls to whatever your workbook name is. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Mike wrote: Hi everyone: Say I have a 2D matrix, or x-y matrix liks this: March April May 1 2 3 Say March, April, and May are cells in a different sheet. Now, If I highlight 2-April cell, for example, I want to be linked to "April" cell in that different sheet. And so on for other. I know how to do hyperlinking but that is NOT what I am asking. I have here what you might call "Conditional Hyperlink" that I would like to have. Is this doable? Any other way? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Auotomating "Sort" in Excel | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |