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

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

Hi Charles

It was really a helpful site. i tried it with my workbook & it worked. But
now my problem is I am having 30 more named regions :(.
I think a macro should solve it or I think the list should be created based
on the selection (instead of creating multiple named regions.)

"Charles Chickering" wrote:

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."