Bonjour, I have a difficult one here (for me at least).
I am trying to fill a series of cell that are dropdownlist themselves and there adjacent cells based on the selection made in an other dropdownlist.
Scenario :
The spreadsheet is used to build spaceship (yeah, I know, but it's an example )
To build a space ship, you need to choose, from a list of components and the number of each components. Not every spaceship needs the same components and not de same number of the chosen components.
Components :
Cockpit
Wing
Cargo
Passenger suit
Engine
Radar
Weapon
I have a list of 15 dropdownlist cells where you can choose the component you want to build the ship and the number of component. You can freely create your ship OR use a pre made ship from a dropdownlist.
The choice you make for your pre-build ship will define what is going to appear in the dropdownlist below along with their numbers.
I know how to work with VLOOKUP and different array, I don't know, though, how to work with a cell that will be a vlookup OR a dropdownlist and I don't know how to work with multiple table since not all table have the same number of items no how many items.
I hope this weird example is clear enough and that you will be able to point me in the right direction.
Thanks,
Regards,
Bookmarks