I have a table with a parent-child relationship and some other data:
In a tree format this would look like this:
I want to have 3 dependent dropdowns, one for each level.
For example:
Any ideas about how to achieve this (with or without VBA)?
| Child | Parent | Info |
| 1 | … | |
| 2 | 1 | … |
| 3 | 2 | … |
| 5 | 2 | … |
| 451 | 2 | … |
| 511 | 1 | … |
| 721 | 1 | … |
| 722 | 721 | … |
| 724 | 721 | … |
| 1275 | 721 | … |
| 1294 | 721 | … |
| 1308 | 1 | … |
| 1309 | 1308 | … |
| 1311 | 1308 | … |
| 1460 | 1308 | … |
| 1479 | 1308 | … |
| 1493 | 1 | … |
In a tree format this would look like this:
I want to have 3 dependent dropdowns, one for each level.
For example:
- I choose 1 in the 1st.
- Then in the 2nd I can only choose from [2, 511, 721, 1308, 1493].
- Would I choose 721, then for the 3rd dropdown my options should be limited to [722, 724, 1275, 1294].
Any ideas about how to achieve this (with or without VBA)?
