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

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

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

--
Marv Lusk



"Tom Ogilvy" wrote:

> 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

Oh DUH, I got it!

Thanks!
--
Marv Lusk
Boise Corporation


"MarvInBoise" wrote:

> 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
>
> --
> Marv Lusk
>
>
>
> "Tom Ogilvy" wrote:
>
> > 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