list of items click on it and have excel jump there

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Headacheaday - 07 Feb 2008 03:06 GMT

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.

Reply to this Message

Roger Govier - 07 Feb 2008 11:27 GMT

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

Signature

Regards
Roger Govier

> 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.
[quoted text clipped - 7 lines]
>
> When clicking on # of students curser jumps to say 37.

Reply to this Message

Gord Dibben - 07 Feb 2008 17:57 GMT

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

>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.
[quoted text clipped - 7 lines]
>
>When clicking on # of students curser jumps to say 37.

Reply to this Message