Excel 2007 : need to create drop down list with conditioning?

[yocin]

Hi all , my boss askes me to create a form for addition and deletion of users from a system. I can do the drop list but not the validation part, hence I need some help fr kind souls. This is an example of the requirements.

Column A: 3 types of user groups 1)APAC 2)ED 3)POP (DROP DOWN LIST)


Column B:

If 1)APAC is selected in Column A, display 3 choices 1)Creator 2)Inquirer 3)Verifier (DROP DOWN LIST) in Column B


If 2)ED is selected in Column A, display 2 choices 1)Creator 2)Verifier (DROP DOWN LIST in Column B


If 3)POP is selected in Column A, display 1)Inquirer 2)Security Administrator (DROP DOWN LIST in Column B


Your kind assistance will be much appreciated, thank you very much!

[Palmetto]

See this page on using:

Excel Data Validation -- Create Dependent Lists