list of items click on it and have excel jump there
 

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.

list of items click on it and have excel jump there
 

Hi
Highlight the cell with # of Students
Right clickInsertHyperlinkchoose Place in this Document in the left
PaneEnter cell reference containing the value 37 e.g Sheet2!D9OK

--
Regards
Roger Govier

"Headacheaday" wrote in message
...
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.

list of items click on it and have excel jump there
 

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

On Wed, 6 Feb 2008 19:06:01 -0800, Headacheaday
wrote:

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.