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