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.