ExcelBanter - Creating a drop down list

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Creating a drop down list (https://www.excelbanter.com/new-users-excel/104161-creating-drop-down-list.html)

Creating a drop down list

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

Creating a drop down list

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?

All times are GMT +1. The time now is 07:24 AM.