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!
Bookmarks