hi,
Consider i have a Coulmn, 'Grade' which can be A,B,C,D and F and list of students and other field.
Now i need to create a list box for the grades. i.e if i select grade A from the list box only the students with grade A should be listed and if i select grade B from the list box only the students with grade B should be listed etc.
How can i do this,.??
I tried something with Data->Validation and selecting List, still I'm unable to get what i need.
So how can i do it.?
Thanks in advance.
Consider i have a Coulmn, 'Grade' which can be A,B,C,D and F and list of students and other field.
Now i need to create a list box for the grades. i.e if i select grade A from the list box only the students with grade A should be listed and if i select grade B from the list box only the students with grade B should be listed etc.
How can i do this,.??
I tried something with Data->Validation and selecting List, still I'm unable to get what i need.
So how can i do it.?
Thanks in advance.
