Hi all,

I need to make a form, where it is possible, to make selection from multiple dropdown menus.
The "basic" datavalidation is not ok, as I have several overlapping items.

I have a table similar to this (obviously bigger):
type	size	color	longname	name
1	big	green	sadfddd		sa
1	small	green	aasfsfd		aa
2	big	green	sgsddd		sg
2	big	red	sddddd		sd
2	big	red	sfdsfsdd	sf

I need dependent dropdowns, where I can make a selection from left to right, and the dropdown shows only the available options.

VBA solution is also fine, I'm happy to learn it.

Thanks!