My question is pretty simple, but I can't seem to find any information on how to achieve my goal - which is to create a drop down list based on data in a table.
My table list aisles and slots within the aisle (warehouse storage), so the 1st column is AISLE, 2nd column is SLOT. From here I need 2 drop down boxes, 1 to select the aisle (which I already have), and the 2nd drop down to list only the slots within that aisle).
My sheet is 30k+ lines long, so if I can avoid creating an actual list for each aisle it would save me hours of time, and assuredly lots of unnecessary processing power.
My table list aisles and slots within the aisle (warehouse storage), so the 1st column is AISLE, 2nd column is SLOT. From here I need 2 drop down boxes, 1 to select the aisle (which I already have), and the 2nd drop down to list only the slots within that aisle).
My sheet is 30k+ lines long, so if I can avoid creating an actual list for each aisle it would save me hours of time, and assuredly lots of unnecessary processing power.
