list of values - Dynamic lists based on different list values

[Lynn G.]

Hi!

I am trying to create a worksheet that will be used for data entry of
values. I have two categories - Type and Subtype.

Type is a list of values. What I am trying to do is dynamicly create a list
of values in Subtype based on the value selected in Type.

For example: If Type contains: T1, T2, T3, and the user selects T2, I want
the list of values in Subtype to display the values S1, S2, S3, etc...

How do I set up that formula/macro?

Many, many thanks!
--Lynn

 

[Debra Dalgleish]

You can create dependent data validation lists. There are instructions here:

http://www.contextures.com/xlDataVal02.html