To set up a list for users to select from, on the menu bar, click on
"Data". Then "Validation". Under the settings tab in the "Allow"
window select "List". Under "Source" enter the range of data you want
to be in the list. This will create a pull down menu when the user
activates that cell.

P.S. The list of items needs to be in the same sheet.

Hopefully this will help you.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=480850