Debra Dalgleish's site:

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

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

--
Regards,
Tom Ogilvy


"MarvInBoise" wrote:

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