Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 3rd 05, 03:35 PM
Mikey
 
Posts: n/a
Default 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   Report Post  
Old May 3rd 05, 08:07 PM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Statement with ANDs Stephen Excel Discussion (Misc queries) 2 April 11th 05 04:41 PM
Trouble with a conditional statement Jim New Users to Excel 2 April 10th 05 10:13 PM
IF Statement that's conditional on multiple IF Stmts in other cell Pat Excel Worksheet Functions 1 March 26th 05 10:31 PM
How do I write a conditional statement in Excel to count if two c. marblelife Excel Worksheet Functions 2 January 16th 05 11:16 PM
Conditional if statement Matt Stanley Excel Worksheet Functions 2 November 10th 04 04:47 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017