It is quite easy to create a dependent list; look here for details:
http://www.contextures.com/xldataval02.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Khaledity" wrote:

Hi,

Please I need to know how to link 1 combo box to another.

Example:
- I have a list of departments (Production, IT, HR, Finance), and a
list of job titles (all positions in the company)
- I want to see only relevant job titles when I choose a specific
department. i.e. when I choose HR department, I want to see only
relevant titles (Training Specialist, Recruitment Coordinator,
Compensation Analyst)

Please advise.

Thanks.

Khaledity