Data Validation Question

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

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
 
Back
Top