Hi all.
I have a worksheet with col A populated by reoccuring numbers (LINES), and col B by unique text (VARIANTS) ...
A B
= =
2 Bananas
6 Oranges
3 Apples
3 Grapes
6 Pineapple
2 Strawberries
3 Kiwi
etc
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
Oranges
Pineapple
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.
Thanks
Excel 2003
Windows XP