On Sep 11, 11:05*pm, Billy Liddel
wrote:
Try this at Debra's site:

http://www.contextures.com/xlDataVal10.html#AddCombo

Peter



"Khaledity" wrote:
On Sep 11, 9:01 pm, ryguy7272
wrote:
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- Hide quoted text -

- Show quoted text -

Thanks a lot, it was of great help. What if I want to do the same but
with combo boxes? is it doable?- Hide quoted text -

- Show quoted text -

I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!