Drop Down Box

[harefeld]

There is a drop down box that can be inserted in a
spreadsheet that will go to a second sheet, and will show
a listing of names and allow you to pick the exact name on
the second sheet and show it on the first sheet. Can
anyone tell me how to get this drop down box? Thanks.

 

[Debra Dalgleish]

You can use Data>Validation, and refer to a named range on the second
sheet. There are some instructions here:

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

 

[Chip Pearson]

I believe you are referring to Data Validation, available from the Data
menu. See http://www.contextures.com/xlDataVal01.html for additional
details.