The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list. To create the Region ...

How to add color to an Excel drop-down list. If you’ve used data validation controls, you know how easy they are to add and how helpful they can be.