I have a worksheet with col A populated by reoccuring numbers (LINES), and col B by unique text (VARIANTS) ...
In another worksheet I have a cell which drop-down list that simply references a range of numbers 1-6 (SELECT_LINE).
Below the above cell I want to create a drop-down list that is only populated by a list of VARIANTS that correspond with the LINE e.g. If i select 6 in the drop-down my second drop-down will contain
Can anybody help me out? I don't need a detailed explaination, if you can point me to the function(s) I should be using I can probably progress from there.