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!!!