I would like to know how to make a pick list (a "list" of names) conditional
on what was picked in the previous column pick list (e.g. of the 4 main areas
of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
within each main area. I would like to format/program the second pick list
(coumn B) to only show the list of sections corresponding to the 'main area'
selected in column A. Then I need to do this for a third pick list (specific
equipment). If you have an example, it would be appreciated.
Thank you.

Hi Stewart,

See Debra Dalgleish's Dependent List page at:

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

See also XlDybnamic's page on Dependent Dropdowns:

http://www.xldynamic.com/source/xld.Dropdowns.html


---
Regards,
Norman



"Stewart" wrote in message
...
I would like to know how to make a pick list (a "list" of names)
conditional
on what was picked in the previous column pick list (e.g. of the 4 main
areas
of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
within each main area. I would like to format/program the second pick list
(coumn B) to only show the list of sections corresponding to the 'main
area'
selected in column A. Then I need to do this for a third pick list
(specific
equipment). If you have an example, it would be appreciated.
Thank you.