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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract list of values from a list 6
Change drop down list in one cell based on values in other cells 2
How do I show that a drop down list exists in a cell? 1
Filtered drop down list 2
Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List 7
Help with worksheet and math functions 5
How to Link drop-down list? 2

Back
Top