How do u see what has been selected in a comboBox in a cell and put that value in a cell? Or How do you change a Validation List on the basis that things can be added to the list in the future. B/C this is what im trying to do:

Depending on which customer gets selected from a list (Combo or Validation, but Validation if at all possible), I want all of that customers parts to be available in another cell. But lets say I change customers I want the parts cell to change. I attached the Spreadsheet that I need to make this work on if what I said isnt clear enuff.

Daxton