Sara, try this article from Ozgrid on dependant validation lists:
http://www.ozgrid.com/Excel/dependent-lists.htm
--
Charles Chickering

"A good example is twice the value of good advice."


"Sara Sun" wrote:

I am using excel workbooks in collecting data from different clients. But i
happen to do some intermediate cleaning up work before i send out the
workbooks to different clients.
For example, i can explain my situation as having a shoe catalog (in one
spreadsheet) and asking clients to pick the number and variety of shoes (in a
second spreadsheet). Shoe Catalog spreadsheet has gender, size, color. I have
to do a manual clean up of unwanted gender before i send to the vendor (say i
know some vendors dont want kids shoes or womens shoe). this first
spreadsheet is hidden & vendor only uses the second spreadsheet.

I am thinking there ought to be a way (in the second spreadsheet) so that
when the vendor picks up gender, the available sizes shows up (as a drop down
list) automatically in the second list. so when he picks up a size, then the
available colors shows up as a drop down list.

i think it is really a long explanation about my situation. thanks for
reading

Sara