Updating cells based selection drop down list data validation Dating quote
To do this, we would need to use helper columns and formulas.As soon as you make the selection from the drop down, you need Excel to automatically identify the records that belong to that selected item. Here are the steps to create helper columns: Now we need to extract the data for these rows only, which displays the number (as it is the row that contains that country).The following example shows you how to use Excel formulas to create a variable drop-down list.(If you are not familiar with drop-down lists in Excel, you may want to first view the page on How to Create a Basic Drop-Down List in Excel).The spreadsheet below contains a list of members of staff, split into teams.
Data validation rules allow you to constrain the values that can be entered into a worksheet cell.We will put this drop-down list into cell G4 of the spreadsheet.To do this: You will now have a drop-down menu in cell G4, that displays the team members relating to the team name that is currently typed into cell G2 (see below).You can define one or more data validation rules for your worksheet.Typically, you define a separate data validation rule for each column in your worksheet where you need to constrain user entered values.
As soon as I select any country from the drop-down, the data for that country gets extracted to the right.