Greetings,

I have two cells with Data Validation List. The first chooses from a
list of names. The second list will change according to which name is
picked from the first list.

For example the first list contains:

John
Bill
Cathy
Ann

The second list if John is chosen:

Johnson
Miller
Smith

If Bill is chosen:

Anderson
Carson
Williams
Hansen

If Cathy is chosen:

Jackson
Harrison
Otting

If Ann is chosen:

Davis
Garnet
Oliver

Is there anyway to accomplish this?

Any help would be most appreciated.

TIA

-Minitman

Hi
see:
http://www.contextures.com/xlDataVal02.html
and
http://www.xldynamic.com/source/xld.Dropdowns.html

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
Greetings,

I have two cells with Data Validation List. The first chooses from a
list of names. The second list will change according to which name
is
picked from the first list.

For example the first list contains:

John
Bill
Cathy
Ann

The second list if John is chosen:

Johnson
Miller
Smith

If Bill is chosen:

Anderson
Carson
Williams
Hansen

If Cathy is chosen:

Jackson
Harrison
Otting

If Ann is chosen:

Davis
Garnet
Oliver

Is there anyway to accomplish this?

Any help would be most appreciated.

TIA

-Minitman

Hey Frank,

This looks like what I was looking for.

I will try this out.

Thank you

-Minitman


On Thu, 23 Sep 2004 20:09:36 +0200, "Frank Kabel"
wrote:

Hi
see:
http://www.contextures.com/xlDataVal02.html
and
http://www.xldynamic.com/source/xld.Dropdowns.html