Hi All,
I have a userform with 2 Comboboxes.
Combobox 1 = Supplier
Combobox 2 = Product
Each Supplier has it's own set of products.
This data is stored in my sheet Data.
Supplier = Range(Range("B60000").end(xlup),"B3")
Product = Range(Range("C60000").end(xlup),"C3")
At this moment my comboboxes contain all items, also duplicate suppliers because there are more than 1 product per supplier.
I would like to populate Combobox 1 with unique suppliers.
I would like to populate Combobox 2 with the list of items based on what supplier is chosen in Combobox 1.
Does anyone have an idea how to?
Thanks
Bookmarks