Hi Roy,

See Debra Dalgleish at

Excel -- Data Validation -- _
Dependent Dropdowns from a Sorted List
http://www.contextures.com/xlDataVal13.html


See also xlDynamic at:

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



---
Regards,
Norman


"Roy" wrote in message
...
I am looking to have a list of products of different styles of the same
thing
and from different manufactures. I would like to pick a product from about
4
drop down list. that if I would pick sink it would only have the sink
styles
left in the next drop down marked styles and ect. with the end having the
price. thanks Roy