Hi,
look Debra web it has excellent explanation

http://www.contextures.com/xlDataVal02.html

"locobo81" wrote:

I am trying to create drop down lists that are dependent on the selection
made from a previous drop down list.

For example - My first drop down list contains the choices A,B,C, or D

In the second drop down list I want specific lists to show depending on the
selection in the first list. So if A was selected from first list the choice
would be E,F or G. But if B was selected the choice would be H,I orJ.

Can anyone help please?