Combo Box - Display Unique Items in List

I have a small fixed size table (10 rows x 9 columns) with company name, department name, company number, etc. entered on each row. These companies are all involved on a specific project and usually change for each project. A particular company can be listed in the table multiple times each having a different department name. I have several combo boxes that I would like to display a unique list of these company names listed in the table. Does anyone know how this could be done?
Thanks,
Gary S

Gary

Have a look at the file I attached to this post

http://excelforum.com/showthread.php?t=611074

I pretty much does the same sort of thing - create a unique list of names for a dropdown. It does go further and makes things dependent for subsequent comboboxes, but it should get you started.


rylo

Originally Posted by rylo

Gary

Have a look at the file I attached to this post

http://excelforum.com/showthread.php?t=611074

I pretty much does the same sort of thing - create a unique list of names for a dropdown. It does go further and makes things dependent for subsequent comboboxes, but it should get you started.


rylo

Thanks for your response. This is helpful.
Gary S

Originally Posted by Leith Ross

Hello Gary,

Here is another method. This macro loads a Drop Down by name with only the unique values from the range specified. Place this code in a Standard VBA Module.

Please Login or Register  to view this content.

Macro Example - This could be attached to a button

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks for your response. Appreciate the help.
Gary S