Hyperlink problem

[klatlap]

can you create a hyperlink on one page to link to text on another pag
that changes it cell location as i import new stocki need the link t
reference a block of text rather than a cell locatio

 

[Dave Peterson]

Can you pick out a unique value in a cell to link to?

If yes, I put that unique value in A1 of sheet1 and looked for that string in
column A of 'Sheet 2'.

Then I used this formula to generate my hyperlink:

=HYPERLINK("#" &ADDRESS(MATCH(A1,'Sheet 2'!A:A,0),1,1,1,"Sheet 2"),
"Click Me to go to " & A1)

(all one cell)