Linking combo box to another

[Khaledity]

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

 

[ryguy7272]

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

HTH,
Ryan---

 

[Khaledity]

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''..








- 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?

 

[Billy Liddel]

Try this at Debra's site:

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

Peter

 

[Khaledity]

Try this at Debra's site:

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

Peter






- Show quoted text -

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

 

[Billy Liddel]

Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me

(e-mail address removed)

and I'll send you a copy.

Peter

 

[Khaledity]

Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me

(e-mail address removed)

and I'll send you a copy.

Peter





- Show quoted text -

Hi Peter,

I couldn't download the file, also I have sent couple of emails but it
bouns back! Please advise.

 

[Billy Liddel]

Sorry the keyboard must have stuck.

(e-mail address removed)

Peter

 

[Khaledity]

Sorry the keyboard must have stuck.

(e-mail address removed)

Peter







- Show quoted text -

Thanks Peter, please check your email.