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

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.

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

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.

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

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.