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.
|