Hi my fellow Excel users,
I've been wrestling with a workbook where I've only one sheet. The sheet has an area which I describe as an user interface and an area which can be described as data area.
The data is (usually) consisted of four columns, but the row count changes from time to time. The data is always printed to same area. It looks like this:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
The UI area is located in the upper left part of the sheet. The UI are contains headers as below. The Result cell (DD3) is the cell where I want to get the group of model names to choose from. In the first drop down (dd1) I want to select from class (and as you can see I need to have unique selections there, for example only SUV, Sedan and Sport) and this should now give only those options in the dd3. In the other hand if I want to only have SUV and from Ford I would get only the Ford SUV model name to dd3. And in the other hand, I want to have only Ford cars, It would present all the Ford cars in drop down dd3 - taken in to account that Class selection (dd1) would then be empty.
<colgroup><col><col><col></colgroup><tbody>
</tbody>Does this make any sense? I've worked my way through all the cascading and dependent unique dynamic drop down tutorials, but don't get my head around this.
BR,
Prestige
I've been wrestling with a workbook where I've only one sheet. The sheet has an area which I describe as an user interface and an area which can be described as data area.
The data is (usually) consisted of four columns, but the row count changes from time to time. The data is always printed to same area. It looks like this:
Model_ID | Manufacturer | Class | Model_name |
1200 | Ford | SUV | Ford SUV model |
1300 | Nissan | Sedan | Nissan Sedan model |
1400 | Tesla | Sedan | Tesla Sedan model |
1500 | VW | SUV | VW SUV model |
1600 | Toyota | Sport | Toyota Sport model |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
The UI area is located in the upper left part of the sheet. The UI are contains headers as below. The Result cell (DD3) is the cell where I want to get the group of model names to choose from. In the first drop down (dd1) I want to select from class (and as you can see I need to have unique selections there, for example only SUV, Sedan and Sport) and this should now give only those options in the dd3. In the other hand if I want to only have SUV and from Ford I would get only the Ford SUV model name to dd3. And in the other hand, I want to have only Ford cars, It would present all the Ford cars in drop down dd3 - taken in to account that Class selection (dd1) would then be empty.
Selection | ||
Criteria1 by Class | Criteria2 by Manufacturer | Results |
DD1 | DD2 | DD3 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
BR,
Prestige