Having one Data Validation cell display a list that is dependent on the
selection made in another Data Validation cell can be done without VBA.
However, you can do this for only one list that is dependent on the
selection in another list.
From what you say, I gather that you want to have more than one list
dependent on another. You want a chain of them. Is that correct?
If so, you will need VBA.
Post back and clarify the number of dependencies you need. HTH Otto
"BEEZ" wrote in message
...
Hello trying to find a way to have a row of dependant columns ,where the
first row has a drop down menu with a list of parts like a lamp body, then
the next cell over shows a list which would change depending on the first
selection. until a whole part # is created from all the indiviual pieces.
That then would return in a different cell a
quantity of available for sale and a price specific to that unique part #.
I
already have a sheet that has the quantities and pricing.