Hi, I am wanting to have a hyperlink in a worksheet which will link to
one of two other worksheets depending on the entry in another cell.

e.g. sheet 1 (A1) possible options are "A" or "B"

If the entry is "A" hyperlink to worksheet 2
If the entry is "B" hyperlink to worksheet 4

The hyperlink is at cell (A7)

Is this possible or an I asking too much of Excel, please?


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=487954