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