Data Validation based on data to left but several columns dependen

[Guest]

I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen
Oranges in column A, I want the choices in column B to be Valencia/Blood,
etc.; if I chose Apples in column A, then I want the column B choices to be
Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula
in B1; however, I now want to expand to columns C, D, etc., so that if I have
chosen Gala in B1, then I have choices in column C, and on and on. HELP!

Thanks!

Marv Lusk
Boise Corporation

 

[Guest]

Debra Dalgleish's site:

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

go down to the "D's" and under Data validation, find dependent dropdown.

 

[Guest]

Ah, is that Office2007? I don't see such a choice in my list under
Data/Validation? Only:
any value
whole number
decimal
list
date
time
text length
custom

 

[Guest]

Oh DUH, I got it!

Thanks!