
This Excel tutorial explains how to create dependent dropdown list where dropdown list values depend on another list value.
Excel dependent dropdown list / dependent validation list
Suppose you have a continent list in Excel (Asia, North America, South America, etc). When an user selects a continent from a dropdown list, the user can then select the second dropdown list which contains all the countries of your selected continent, so the country list is dependent on the continent value.
For ...
Read More