Drop Down List
 

I am trying to create an escalation list. There are three levels of
escalation. For each level I would like a drop down list of employees to
choose from. Once an employee is selected I would like to show their contact
information. What would be the best way to go about doing this?

Drop Down List
 

hi
i think you mean dependent dropdowns or cascading combos.
see this site for an explination.
you can use data validation or combo boxes. the process is pretty much the
same.

Regards
FSt1

"Mesha512" wrote:

I am trying to create an escalation list. There are three levels of
escalation. For each level I would like a drop down list of employees to
choose from. Once an employee is selected I would like to show their contact
information. What would be the best way to go about doing this?

Drop Down List
 

opps.
i guess it would be polite to accually post a site.
http://www.contextures.com/xlDataVal13.html

sorry about that.
Regards
FSt1

"FSt1" wrote:

hi
i think you mean dependent dropdowns or cascading combos.
see this site for an explination.
you can use data validation or combo boxes. the process is pretty much the
same.

Regards
FSt1

"Mesha512" wrote:

I am trying to create an escalation list. There are three levels of
escalation. For each level I would like a drop down list of employees to
choose from. Once an employee is selected I would like to show their contact
information. What would be the best way to go about doing this?