Conditional Drop Down List

[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 Sales Representative. In cell A2, based conditionally on what sales rep was chsoen from the drop down list in cell A1, I want another drop down list for Customer. Depending on the Sales Rep chosen in cell A1, the drop down list in cell A2 will vary.

Any help would be greatly appreciated.

Thanks,

Bogo