Conditional Drop Down List

  • Thread starter Thread starter Bogo
  • Start date Start date
B

Bogo

Is it possible to create a conditional drop down list in Excel.

For example, in cell A1, I have created a drop down list for Sale
Representative. In cell A2, based conditionally on what sales rep wa
chsoen from the drop down list in cell A1, I want another drop dow
list for Customer. Depending on the Sales Rep chosen in cell A1, th
drop down list in cell A2 will vary.

Any help would be greatly appreciated.

Thanks,

Bog
 
if you are starting with a database highlight all and use Data>Filter>Auto
filter
click on any of the arrows to sort the data by category.
 
Back
Top