Creating a drop down list

[Ed]

i want to create a column (A1) where i can choose from a list of clients
How do I create this list and keep it hidden?

 

[Ron de Bruin]

Hi Ed

Add you list on a hidden worksheet

And use this to create the dropdown
http://www.contextures.com/xlDataVal01.html