Please see the attached document.
I have this huge database of items that I want easy access to.
My idea is a Userform with the option of selecting a few categories.
The more categories selected, the less products will show in the last combobox.

If "Blue" is selected under Category1, products 1-10 will show in the last combobox, and only "Green" and "Orange" will show in the Category2-combobox.

Book1.xls