I want to create a Hyperlink (macro) based on cell value Sheet1!A1, where Sheet1!A1 contained formula and is always numeric. This is noted that others Sheets like Sheet2, Sheet3, Sheet3 etc. are always hidden.
e.g. Sheet1!A1=2 Go To Sheet2,
Sheet1!A1=3 Go To Sheet3,
Sheet1!A1=4 Go To...