6 Data Validation lists depending on 1 cell value
 

In have been looking over Debra Dalgleish's info (great stuff there)
and the advanced newsgroups but can't seem to find an answer to my
problem.

I have one validation box with 6 manufacturers in it, there are then 6
other cells with data validation in which depend on the value chosen in
the first cell. i.e. (in short)

Maker aaa bbb ccc
aaa part a part a part b
bbb part b part g part f
ccc part f part h part h

Indirect only links to first, I think I need offset but cannot work it
out, (comes of being old I suppose). I'm sure I am missing something
straightforward.
Any help would be much appreciated
Regards
Bill

Do the six cells require different lists? For example, does list 1 show
PartA for the selected manufacturer, and list 2 show PartB?

If so, how is the information stored in your workbook?

beel wrote:
In have been looking over Debra Dalgleish's info (great stuff there)
and the advanced newsgroups but can't seem to find an answer to my
problem.

I have one validation box with 6 manufacturers in it, there are then 6
other cells with data validation in which depend on the value chosen in
the first cell. i.e. (in short)

Maker aaa bbb ccc
aaa part a part a part b
bbb part b part g part f
ccc part f part h part h

Indirect only links to first, I think I need offset but cannot work it
out, (comes of being old I suppose). I'm sure I am missing something
straightforward.
Any help would be much appreciated
Regards
Bill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra, nice to hear from you. Perhaps a better example would be
(just 3 for ease)

Maker aaagrades bbbgrades cccgrades aaabond
aaa vsp hye jpt vs
bbb thx jut lmd vbr
ccc thh kjh kbr
ytr

and so on for bbbbond cccbond and 3 other features.
It is stored as a series of lists on another worksheet in the same
book. Makers are in a name group 'Brand' which is the primary
question. The drop down boxes are needed for the relevant questions
grades, bond etc. I hope this is clearer

i.e.
Brand AAA

Bond choose from vs,kbr,vbr

grades choose from vsp,thx,thh,ytr
and so on

I hope this is clearer!

many thanks for your interest
Bill

Based on your sample data, I'll assume that the lists are named with the
Brand name, and the category name, e.g. aaagrades, aaabond

In the cell where you want the Bond dropdown, set the data validation
list source to: =INDIRECT($C$2&"Bonds")

where cell C@ contains the dropdown for brand.

For the Grades dropdown, set the list source to:
=INDIRECT($C$2&"Grades")

beel wrote:
Hi Debra, nice to hear from you. Perhaps a better example would be
(just 3 for ease)

Maker aaagrades bbbgrades cccgrades aaabond
aaa vsp hye jpt vs
bbb thx jut lmd vbr
ccc thh kjh kbr
ytr

and so on for bbbbond cccbond and 3 other features.
It is stored as a series of lists on another worksheet in the same
book. Makers are in a name group 'Brand' which is the primary
question. The drop down boxes are needed for the relevant questions
grades, bond etc. I hope this is clearer

i.e.
Brand AAA

Bond choose from vs,kbr,vbr

grades choose from vsp,thx,thh,ytr
and so on

I hope this is clearer!

many thanks for your interest
Bill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra you are a wonderful person!!
When I get fed up with the internet and some of it's issues I think of
these groups and remember this is what it is all supposed to be about.

Again many thanks
Bill

You're welcome! There's lots of great information posted in these
newsgroups, so I'm glad you found your way here.

beel wrote:
Debra you are a wonderful person!!
When I get fed up with the internet and some of it's issues I think of
these groups and remember this is what it is all supposed to be about.

Again many thanks
Bill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I'm trying to do the same thing as beel, and I tried to use the example in
this thread by Debra, but I couldn't get it to work. Debra, can you try to
explain a little more to me how this works? Maybe use an even simplier
example, and list what goes into which cell, so I can try it.
In your solution, what is &amp, and &quot?

Bill Carr

"Debra Dalgleish" wrote:

You're welcome! There's lots of great information posted in these
newsgroups, so I'm glad you found your way here.

beel wrote:
Debra you are a wonderful person!!
When I get fed up with the internet and some of it's issues I think of
these groups and remember this is what it is all supposed to be about.

Again many thanks
Bill



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

The newsgroup interface that you're using must be adding the &amp and
&quot, because they weren't in the original. You might get a better view
of the thread in Google:


http://groups.google.pt/groups?&thre...resXSPA M.com

And there are instructions here for dependent data validation lists:

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

Bill Carr wrote:
I'm trying to do the same thing as beel, and I tried to use the example in
this thread by Debra, but I couldn't get it to work. Debra, can you try to
explain a little more to me how this works? Maybe use an even simplier
example, and list what goes into which cell, so I can try it.
In your solution, what is &amp, and &quot?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

The first link is a google page all written in another language. ??? But the
second link was great! The example in the second link was just what I was
trying to do. Thank you very much, Debra!

"Debra Dalgleish" wrote:

The newsgroup interface that you're using must be adding the & and
", because they weren't in the original. You might get a better view
of the thread in Google:


http://groups.google.pt/groups?&thre...resXSPA M.com

And there are instructions here for dependent data validation lists:

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

Bill Carr wrote:
I'm trying to do the same thing as beel, and I tried to use the example in
this thread by Debra, but I couldn't get it to work. Debra, can you try to
explain a little more to me how this works? Maybe use an even simplier
example, and list what goes into which cell, so I can try it.
In your solution, what is &, and "?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! I'm glad the information on my site helped you.

If you want to try the google page again, this link might work better:


http://groups.google.ca/group/micros...c40?&lr=&fwc=1

Bill Carr wrote:
The first link is a google page all written in another language. ??? But the
second link was great! The example in the second link was just what I was
trying to do. Thank you very much, Debra!

"Debra Dalgleish" wrote:


The newsgroup interface that you're using must be adding the & and
", because they weren't in the original. You might get a better view
of the thread in Google:


http://groups.google.pt/groups?&thre...resXSPA M.com

And there are instructions here for dependent data validation lists:

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

Bill Carr wrote:

I'm trying to do the same thing as beel, and I tried to use the example in
this thread by Debra, but I couldn't get it to work. Debra, can you try to
explain a little more to me how this works? Maybe use an even simplier
example, and list what goes into which cell, so I can try it.
In your solution, what is &, and "?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html