Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use HYPERLINK in a conditional statement between sheets
How can I use the HYPERLINK command in a conditional statement so that I can
move from one sheet to another based upon the conditions? I'm setting up a Menu with check boxes. I'm testing the boxes to either produce a link to one sheet in the workbook or another link to another sheet in the workbook. I don't want to do any coding as this should be possible without resorting to that; however, the suggesting in the help files does not work for Excel 2000. It should be: =HYPERLINK("[Workbook]Sheet1!A1","Click Here") so the conditional statement would look like this: =IF(A1=A2,HYPERLINK("[Workbook]Sheet1!A1","Click Here"),False) so if A1=A2 I should get "Click Here" point me to Sheet1 in the A1 location. Any help would be wonderful. |
#2
|
|||
|
|||
I put this in C1 of that same worksheet:
=HYPERLINK(IF(A1<A2,"#"&ADDRESS(ROW(),COLUMN()), "c:\my Documents\excel\book1.xls#Sheet2!c99"),"Click Here") (one cell) If the values are different, it links to the cell holding the formula. Else it opens book1.xls to sheet2 cell C99. Mikey wrote: How can I use the HYPERLINK command in a conditional statement so that I can move from one sheet to another based upon the conditions? I'm setting up a Menu with check boxes. I'm testing the boxes to either produce a link to one sheet in the workbook or another link to another sheet in the workbook. I don't want to do any coding as this should be possible without resorting to that; however, the suggesting in the help files does not work for Excel 2000. It should be: =HYPERLINK("[Workbook]Sheet1!A1","Click Here") so the conditional statement would look like this: =IF(A1=A2,HYPERLINK("[Workbook]Sheet1!A1","Click Here"),False) so if A1=A2 I should get "Click Here" point me to Sheet1 in the A1 location. Any help would be wonderful. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Statement with ANDs | Excel Discussion (Misc queries) | |||
Trouble with a conditional statement | New Users to Excel | |||
IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions | |||
Conditional if statement | Excel Worksheet Functions |