T
Tanya
Hi
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'
B1 has a drop box with reference to two tables 'spell' and 'math'
Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].
Note: I have heavily simplified my scenario, I hope it makes sence.
Kind Regards
Tanya
I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'
B1 has a drop box with reference to two tables 'spell' and 'math'
Is this possible or beyond the scop of Excel? The reason I want to have two
lists in B1 is to have less to scroll through [my lists will be quite long].
Note: I have heavily simplified my scenario, I hope it makes sence.
Kind Regards
Tanya