hyperlink or bookmark based on cell value
 

Hi,
I would like a bookmark or hpyerlink to to change according to a cell
value, eg if cell c1= sheet 1 then bookmark = sheet 1, if cell c2 =
sheet 2 then bookmark = sheet 2.

Thanks for anything

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=543023