Combo Box for a list of records

D

dascooper

How can I create a combo box that can be used in a column of data (ie, having
a column of states and a combo box of all the states instead of typing in for
each record)
 
D

dascooper

I figured out how to use data validation for this. The next step would be to
filter the list based upon the value in another field (in the same
record/row). IE, if I selected Illinois, the City colum would only list
valid cities in IL? Any suggestions?
 
A

Aqib Rizvi

One way is to create Filter. Select your data including the column
header. Then click on Data Filter. From DropDown boxes on the top
row you can make a selection.

AQIB RIZVI
 
Top