“Is it possible to make one validation column dependent upon choices from another validation column?”
Here’s an example;
Imagine you have 2 columns in an Excel list, one column for the Make of car entries and another column for the Model of the car entry. If a user selects “Ford” as the make, when a model is selected they should only be able to pick from “Ford Models” (Mustang, Escort, Focus). If “Chevy” is chosen, then they should only be able to pick from “Chevy Models”.
This is definitely possible and can be accomplish is a number of ways. My first thought was to write some VBA code that would identify which Make was selected and then populate the appropriate choices through the code. Then I thought this would be a place to create an Excel VBA UserForm to control the users experience with specific controls to interface with in order to do the data entry.
Both the above would work great, but takes some knowledge of VBA and maybe not entirely necessary. I finally decided on using Excel’s Data Validation feature, combined with Name Ranges and Excel’s INDIRECT Function.
Here is how it goes…
There you have it. Click into the Make column, select a Make. Now click the Model column and you will get the appropriate Models to chose from.
Hope you’ve enjoyed this. For the working file, download here: ExcelDynamicValidation-01