Dropbox selection

[SandMNichol]

Good morning;

I have a dropdown list for departments in my company. Each of thes
departments have different further divisions. I would like that after
choose the department, that my next dropdown list only have the furthe
divisions associated with that department as choices. I am havin
difficulty finding the way to do this. Can anyone give me a hand wit
this? I am using Excel2003. Thank you for your assistanc

 

[Claus Busch]

Hi,

Am Sat, 12 May 2012 18:14:55 +0000 schrieb SandMNichol:

I have a dropdown list for departments in my company. Each of these
departments have different further divisions. I would like that after I
choose the department, that my next dropdown list only have the further
divisions associated with that department as choices. I am having
difficulty finding the way to do this. Can anyone give me a hand with
this? I am using Excel2003. Thank you for your assistance

take a look:
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html


Regards
Claus Busch

 

[Mazzaropi]

Good morning;
I have a dropdown list for departments in my company. Each of thes
departments have different further divisions. I would like that after
choose the department, that my next dropdown list only have the furthe
divisions associated with that department as choices. I am havin
difficulty finding the way to do this. Can anyone give me a hand wit
this? I am using Excel2003. Thank you for your assistance

Dear *SandMNichol*, Good Afternoon.

It´s always a good practice to search the question in the forum.
This doubt was discussed here a lot of times before.

You can find too any information here:
http://www.contextures.com/xlDataVal02.html

But if you prefer, you could show us an example of the workbook to mak
it easier to understand the issue?
Seeing the worksheet, the help will be quicker and more effetctive t
solve your question.

Have a nice day