Hi Debra
Yes the answer in C does depend on what was selected in B, but
not like the one in the link. It needs to be another drop down list.

--
ch


"Debra Dalgleish" wrote:

Do the values in column C depend on what was selected in both A and B,
or just the selection in B?

If it's just dependent on B, use the technique shown he

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

Gripper wrote:
Hi Gerry
all the data in cols A are from one drop down list and what ever item you
pick from that list gives you a choise from another drop down list in B and
what ever item you pick from B that list gives you a choise from another drop
down list in C

Like you said earlier,
I want to be able to enter a value in say A1 from a drop down and this will
generate a choice
of values I can enter in B1 and that will generate a choice of values you can
enter in C1

Thanks for the help Gerry


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html