is it possible to do a drop down list that bring up another drop down in the same cell but populate the second list based on the selection from the first list?
Regarding your input, thank you. if, on sheet19, I listed the general materials in their own cells on their own column and all of the subselections for each specific material to the right, would that make getting list data easier?