Good morning;

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

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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 he
http://www.contextures.com/xlDataVal02.html

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

Have a nice day.