How to link a drop down menu to another one?

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
 
S

Stephen

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
 

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

Linking combo box to another 8
Need help to update a column when Drop Down List is changed 0
Conditional Formatting for a dashboard with a drop down menu 0
complicated drop down menu question 1
How do I change fonts in a DV drop down menu 1
How do I create a drop-down menu to sort data? 5
How to pop up correspoding values by clicking on drop down menu? 1
Populate a second field from a Drop Down Menu 0

Top