Dropdown windows to select products within excel?

[Steve]

I have a situation where two sales reps want to use a
spreadsheet to select (from a dropdown menu) perferrabily
within excel, one product per line (enter quantity), so it
could then do a total cost. I have never done this in
excel before - is there a way to enter the items so then
would then be available via dropdown? There are only
going to be about 20-60 items. The file then would be
sent via e-mail to the warehouse.
I was thinking FileMaker - or Access - but they wish to
use Excel.
Thoughts, suggestions?

Thanks!

Steve

 

[Frank Kabel]

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