excel drop downs

[rich]

how do I build and maintain a drop down.
I have information on 1sheet and need a drop down on
another sheet to show that information and my employees to
easily be able to pick things off from that list to finish
order forms.

Can someone please help.

 

[Casey]

Rich,
Attached is a small workbook that will hopefully help you understan
drop down lists. I've added a few other things that may help.
Case

Attachment filename: named ranges and drop downs.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50468

 

[Frank Kabel]

Hi
you may also have a look at
http://www.contextures.com/xlDataVal01.html