"Pick From List"

[Tim Hagedorn]

I would like to make a drop down menu based on a list
that I have on a seperate sheet. How do I do that?

 

[John Wilson]

Tim,

Is this what you're looking for:
http://www.contextures.com/xlDataVal01.html

John

 

[J.E. McGimpsey]

One way:

Name your list (say, myList)

Select the cell to have the dropdown. Choose Data/Validation/List
and enter

=myList

in the Source textbox.