Hi

See
http://www.contextures.com/xlDataVal13.html
and its related linked articles.

HTH. Best wishes Harald

"William Jones" <William skrev i melding
...
I need to create a drop down parts list in a cell pre-named. ie: cell name
parts drop down has a list of sub part that belong to a product number in
a
different cell