Help Me!!!

  • Thread starter Thread starter beng120
  • Start date Start date
B

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!!
 
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)
 
Back
Top