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.

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.
--
Regards,
Dave


"Visiting Angel" wrote:

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.

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.