I've been trying to find a way of doing this with dependent dropdowns, but I am yet to be successful with my specific tables. In essence I'm looking to create a validation list based on a "filtered" results list from another table.
These are structured tables:
Table1 (with static values to be "filtered" )
id Items
2 ItemAA
2 ItemAAA
3 ItemZZ
5 ItemXY
5 ItemXYZ
2 ItemCC
Table2 (With the Validation List dropdown)
idFromTable1 RelatedOptionFromFilteredDropdownList
2 ItemAA (dropdown lists: ItemAA, ItemAAA, ItemCC)
5 ItemXY (dropdown lists: ItemXY, ItemXYZ)
2 ItemCC (dropdown lists: ItemAA, ItemAAA, ItemCC)
3 ItemZZ (dropdown lists: ItemZZ)
Edit: using formulas, not VBA
Edit2: Both ID and Items will be counted on the hundreds or thousands.
Thank you