How do I insert a drop down list button from an excel worksheet?

[Guest]

I an revising a schedulig form and need to create some drop down menus on one
spread sheet from data on another worksheet. How do I insert the drop down
button on the schedule from the list on the data sheet?

I created a list of time options and employee options and need to have them
on a pull down button on the schedule so that various times or employees can
be selected for the schedule.

Thank you for any assistance you can provide.

 

[Guest]

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.

 

[Gord Dibben]

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