Hi,
I am trying to create excel sheet where user will choose brand and model for a car. I would like this to be a dropdown and option in list two will be based on selection in first list.
I have tried to work this with "Data validation" but I can only have fixed ranges with that. Range must be based on values in cells and selections user will make.
Please see attached for better explanation. I doubt this is difficult, just me that complicate things. Please ignore wrong model names, this is just to illustrate problem.
Bookmarks