Creating Dependent Lists: HOWTO?

[network_engineer]

Hi all,

How would I create dependent lists? E.g. Column A has a list, and based on the selection in the list, I would like Column B to show a dependent list.

So, if I select Animals from the list in Column A, in Column B, the dependent list shows different animals; however, if choose Birds, then the list is reflected accordingly.

Thanks for any help.

Kind regards.

 

[VoG]

This should help http://www.contextures.com/xlDataVal02.html

 

[T. Valko]

Hi all,

How would I create dependent lists? E.g. Column A has a list, and based on the selection in the list, I would like Column B to show a dependent list.

So, if I select Animals from the list in Column A, in Column B, the dependent list shows different animals; however, if choose Birds, then the list is reflected accordingly.

Thanks for any help.

Kind regards.

See this...

http://contextures.com/xlDataVal02.html