How to link a drop down menu to another one?

  • Thread starter Thread starter Khaledity
  • Start date Start date
K

Khaledity

Hi All,

I need your help to line the first drop down menu which contains
department titles; HR, Marketing, etc... to the second drop down menu
which includes specific titles related to each department.

First Dropdown Menu
HR
Marketing

and when I select HR, the following appears;
Recruitment Officer
Training Coordinator
Performance Management Specialist.

I appreciate your prompt response.

Khaled
 
Khaledity said:
Hi All,

I need your help to line the first drop down menu which contains
department titles; HR, Marketing, etc... to the second drop down menu
which includes specific titles related to each department.

First Dropdown Menu
HR
Marketing

and when I select HR, the following appears;
Recruitment Officer
Training Coordinator
Performance Management Specialist.

I appreciate your prompt response.

Khaled
Click to expand...

You need to set up a dependent list. It is explained very well here:
http://www.contextures.on.ca/xlDataVal02.html
 
Back
Top