mcclausky
New Member
- Joined
- Sep 15, 2016
- Messages
- 3
Hello,
I would like to create 3 levels of dependent & dynamic DropDownlists (Data Validation lists) based on the following ranges:
<tbody>
</tbody>
The 3 ranges are created as: Level_1, Level_2, Level_3.
I have tried with several OFFSET formulas and some worked, but unfortunately the OFFSET formula on the DropDowns stops working when you close and re-open the excel file. That's why I'm asking for your help, perhaps there is another way to achieve this?
Your help will be greatly appreciated.
Mc
I would like to create 3 levels of dependent & dynamic DropDownlists (Data Validation lists) based on the following ranges:
LEVEL 1 | LEVEL 2 | LEVEL 3 |
1. ACTIVE | 1.1. ACTIVE CURRENT | 1.1.1. AVAILABLE |
2. PASSIVE | 1.2. ACTIVE NON CURRENT | 1.1.2. ACTIVE EXIGIBLE |
2.1. PASSIVE CURRENT | 1.2.1. ACTIVE FIXED | |
2.2. PASSIVE NON CURRENT | 1.2.2. CUMULATED DEP | |
2.1.1. PASSIVE EXIGIBLE | ||
2.1.2. PASSIVE EXIGIBLE LT | ||
2.2.1. PASSIVE EX. | ||
2.2.2. PASSIVE EX. LT | ||
<tbody>
</tbody>
The 3 ranges are created as: Level_1, Level_2, Level_3.
- DropDown list 1 must display items from range Level_1.
- DropDown list 2 must display FILTERED items from range Level_2. Example: if "1.ACTIVE" is selected on DropDownList 1 then the available items on DropDown 2 should only be: "1.1.ACTIVE CURRENT" and "1.2.ACTIVE NON CURRENT". The formula for the Data validation on DropDown 2 should filter the Level_2 range by the first 2 chars selected on DropDown1, in this case it should return a list of items that start with "1.", which are items 1.1. and 1.2.
- DropDown list 3 must display FILTERED items from range Level_3. Example: if "2.1. PASSIVE CURRENT" is selected on DropDownList 2 then the available items on DropDown 3 should only be: "2.1.1..." and "2.1.2. ...". The formula for the Data validation on DropDown 3 should filter the Level_3 range by the first 4 chars selected on DropDown2, in this case it should return a list of items that start with "2.1.", which are items 2.1.1. and 2.1.2.
I have tried with several OFFSET formulas and some worked, but unfortunately the OFFSET formula on the DropDowns stops working when you close and re-open the excel file. That's why I'm asking for your help, perhaps there is another way to achieve this?
Your help will be greatly appreciated.
Mc