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