I have a template for data entry. I have two fields that I want to create a drop down list for, including townships and shocks. I have made a list of the all the possible townships and possible shocks. How do I tell Excel to use that list. I have tried selecting the cells that I want the data validation rule to cover > list > I =township or = shocks. But it's not working.
Please see attached template.