iansouster
New Member
- Joined
- May 13, 2015
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
Hope someone can help me out there as I've been scratching my head with this problem all morning.
I have a table of information (see below) and I want to be able to create some drop down lists.
What I want to do is in Cell 1 have a drop down list so I can pick a Vehicle, once the vehicle is picked, in Cell 2 I want to be able to pick from the available Makes for that Vehicle type, and then finally in Cell 3 to pick the available Colour.
For example:
If I was to pick Car in Cell1 the options in the drop down list for Cell 2 would be Ford and Vauxhall (no duplicates). After picking Ford in Cell 2 the options in Cell 3 would be Red and Blue.
I'm not sure if this is even possible but I know there are some very smart people on this Forum!
Thanks
Ian
Hope someone can help me out there as I've been scratching my head with this problem all morning.
I have a table of information (see below) and I want to be able to create some drop down lists.
Vehicle | Make | Colour |
Car | Ford | Red |
Van | Peugeot | Green |
Lorry | DAF | White |
Car | Ford | Blue |
Lorry | Scania | Grey |
Car | Vauxhall | Green |
What I want to do is in Cell 1 have a drop down list so I can pick a Vehicle, once the vehicle is picked, in Cell 2 I want to be able to pick from the available Makes for that Vehicle type, and then finally in Cell 3 to pick the available Colour.
For example:
If I was to pick Car in Cell1 the options in the drop down list for Cell 2 would be Ford and Vauxhall (no duplicates). After picking Ford in Cell 2 the options in Cell 3 would be Red and Blue.
I'm not sure if this is even possible but I know there are some very smart people on this Forum!
Thanks
Ian