Just a note to add.

If the list data is another worksheet, you must first give the list a range name
like "MyList"

Then in the DV source dialog you would enter =MyList


Gord Dibben MS Excel MVP

On Mon, 25 Sep 2006 08:46:02 -0700, David Billigmeier
wrote:

Select the cell you would like the drop down menu to be located in.
<Data
<Validation
In the "Allow" box, choose "List"
Then, in the "Source" box enter the location of the data you would like in
the list.