Hyperlink based on a cell value

  • Thread starter Thread starter Scotchie
  • Start date Start date
S

Scotchie

Can anyone help?

In cell A1 I have a value of 3000.

There is a worksheet/tab entitled 3000.

I want to create a hyperlink from an index page that moves to cell B2
of the relevent page based on the value of A1.

I want to do this by Formula rather than Macro and I'm sure that the
INDIRECT function is used somewhere.

Help !!
 
xxx wrote

Insert a hyperlink into cell A1 (Click Insert,select Hyperlink
Under "Named Location in File" Type in 'WORKSHEETNAME'!B2 where WORKSHEETNAME is the name of your worksheet
Also if you want to highlight a certain cell value Type in 'WORKSHEETNAME'!B2:B5 and it will highlight cells B2 to B5 when clicking on the Hyperlink.
----- Scotchie wrote: ----



Can anyone help

In cell A1 I have a value of 3000

There is a worksheet/tab entitled 3000

I want to create a hyperlink from an index page that moves to cell B
of the relevent page based on the value of A1

I want to do this by Formula rather than Macro and I'm sure that th
INDIRECT function is used somewhere

Help !
 
Back
Top