Hi Ed

Add you list on a hidden worksheet

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ed" wrote in message ...
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?