See Debra Dalgleish's website for good instructions:

http://www.contextures.com/xlDataVal01.html

Particularly, the "Name the List Range" section

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Kerry Anne" wrote:

I am trying to insert a drop down list in one worksheet. I have a list of
names on worksheet 2 that I would like to drop down. The directions from Help
are hard to follow and there seem to be missing steps. HELP