"Khaledity" wrote in message
...
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

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