Assigning Cell Values based on Dropdown Menu Selection

[LRoy]

Hello,

Firstly, thank you for taking the time to read this.

I've had an idea of how I'd like to set up my spreadsheet but I'm not sure if it's actually possible, I was hoping someone may be able to offer me some insight. I'm aware it may require some VBA programming to achieve.

Let's say I have a dropdown menu with different options. I'd like to be able to select one of those options and then have that selection determine the values in the cells below.

To give an example:

In this spreadsheet I have a drop down menu that allows me to select the model of the car, and further drop down menus that determine whether the optional extras are included or not.

When I select the basic model, the sheet automatically changes all of the optional extras to 'No'.

When I select the premium model, the sheet automatically changes all of the optional extras that apply to 'Yes'.

Is something like this possible? Any help would be much appreciated.

Thanks in advance!

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Assigning Cell Values based on Dropdown Menu Selection
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.