drop downs

[ahhhmed]

Hi all,

I have a worksheet that contains the following:

Pupils names and their grades

I have a drop down list with the names of the different subjects: English, science, maths, etc

What i want to have is the following:

When I choose a certain subject from the list, I want the grades for that subjects to appear.

Any help is appreciated.

 

[SirJB7]

Hi, ahhhmed!

You have a worksheet with column A(Pupil name), column B(Grade).

You have a dropdown list in columns C:D with (Subjects)... but where's the relation between Grades and Subjects?

Column locations are just for the example.

Regards!

 

[OleMiss2010]

My guess is you are assigning the grades to the student and then selecting the subject after the grade is assigned. If this is the case, then once you have the subjects put into your worksheet you can filter by whatever column they are in so that you only see the subjects you want to see.

 

[ahhhmed]

Thanks all.


What I mean is First I chhose the subject, then I put the marks. I save the file. After that I may choose another subject and put different marks. Now I want to recall the marks for the first subject when I choose it from the DD list.

 

[SirJB7]

Hi, ahhhmed!

Could you please upload a sample file? Thanks.

Regards!

 

[Luke M]

Why not setup the data table like this:

[pre]

Student   Grade    Subject
John        A       Math
John        B      Science
Mary        B       Math
etc

[/pre]
Then all you have to do is put a filter on the Subject column to look at different grades. This would also make things easy to put into a PivotTable, if you choose.

 

[SirJB7]

@Luke M

I was thinking on three lists: first, Subject/Grade; second, Grade/Student/OtherStuff1/OtherStuff2; third, Grade/Subject/Student, this one is the same as your table, and on which it should be performed the pivoting, searching, or whatever needed.

Regards!