Combo Box for a list of records
 

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)

Combo Box for a list of records
 

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?

"dascooper" wrote:

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)

Combo Box for a list of records
 

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