Help Me!!!

[beng120]

I used this forum back in May this year to find out how to make a drop down list on which i can click on the name and it takes me straight to that worksheet. This is working fine but i know need to add more names to the list. I think i was given a formula to out in somewhere but i cannot remember what it was or how to view it. Can someone please tell me how i can do this. Can anyone that replies send it in simplified form. Im only 13 so im not sure of all the theqnical terms for things.

Can Someone Help me please!!

[Bob Phillips]

If your list is say column M, create a name (Insert>Name>Define...) with a
Refersto value of

=OFFSET($M$1,,,COUNTA($M:$M),1)

and then used that range name in the List value of the DV.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"beng120" <beng120.1tn8ye_1123837508.871@excelforum-nospam.com> wrote in
message news:beng120.1tn8ye_1123837508.871@excelforum-nospam.com...
>
> I used this forum back in May this year to find out how to make a drop
> down list on which i can click on the name and it takes me straight to
> that worksheet. This is working fine but i know need to add more names
> to the list. I think i was given a formula to out in somewhere but i
> cannot remember what it was or how to view it. Can someone please tell
> me how i can do this. Can anyone that replies send it in simplified
> form. Im only 13 so im not sure of all the theqnical terms for things.
>
> Can Someone Help me please!!
>
>
> --
> beng120
> ------------------------------------------------------------------------
> beng120's Profile:
http://www.excelforum.com/member.php...o&userid=23188
> View this thread: http://www.excelforum.com/showthread...hreadid=395255
>