See Debra Dalgleish's site for more on dependent lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:54:52 -0700, Susan
wrote:

hello,

Is it possible to create more than 1 list/array in cell B1?
The list chosen would be based on what is in A1?

Thank you,