I am looking to create a drop down menu.
So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance.
So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related
And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related
And….so on…
I have searched for a solution and nothing matches my scenario perfectly. Help!
Bookmarks