Fill Drop Down with List


S

Stockwell43

Hello,

I am trying to use a list I created of employees in a drop down box on a
different worksheet but can't seem to get it to work.

The worksheet my drop down is on is: Schedule
I want it in D9 and make it visible only when it's clicked on. When another
cell is clicked, I want the drop down to disappear but the text to remain.

The worksheet my list is on is: Data
The first cell has a header Employee C1
The list ranges from C2:C16

How do I get the list from Data worksheet to feed the drop down in Schedule?

Any help would be most appreciated. Thanks!!!
 
Ad

Advertisements

J

John C

Unless you want to house your lists on the active worksheet, you will need to
name your list. Go to your menu Insert|Name|Define.
The variable name I chose is EmpList
This refers to: =Data!$C$2:$C$16

Then, in your cell on Schedule, instead of choosing List and
=Data!$C$2:$C$16, you would choose, List and =EmpList.

Hope this helps.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top