list of items click on it and have excel jump there

[Headacheaday]

I need to create a list and then when you click on an item in the list you
will be taken to the corresponding place in the speadsheet.

1. # of students
2. # of teachers
3. # of parents


20 40 30 50 30 90
40 50 43 37 96 72

When clicking on # of students curser jumps to say 37.

 

[Roger Govier]

Hi
Highlight the cell with # of Students
Right click>Insert>Hyperlink>choose Place in this Document in the left
Pane>Enter cell reference containing the value 37 e.g Sheet2!D9>OK

 

[Gord Dibben]

What is the logic behind clicking on # of students and jumping to 37?

Why not jump to 96 or 43?


Gord Dibben MS Excel MVP