Linking drop down lists to another list
 

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?

Linking drop down lists to another list
 

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?

Linking drop down lists to another list
 

Example:.

http://boisgontierjacques.free.fr/fi...ist2Levels.xls

JB
http://boisgontierjacques.free.fr
On 15 mai, 15:19, 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?