Hi,
I have created a dropdown list of more than 4,000 clients in Excel. With the dropdown list, you need to click on the arrow and scroll down to your client name. This is not ideal when you have 4,000 entries...
I browsed the web to find a solution to my problem and I found out I could create a Combo box, which I did. A Combo box is great in the sense that you can either user the dropdown list arrow or type the first letter of your client name.
The only problem I have is that I have the feeling a combo box can be used for a one and unique cell only. In my case, I want to use the combo box for a whole column of the worksheet (e.g. I have 200 jobs, in 200 rows of my Excel sheet, and to all these 200 jobs, I want to add a client from the combo box / dropdown list.
Is this possible? Am I missing something? If it's not possible, this is a shame and I guess I'll have to use Access then.

Many thanks for your help