Hiya!
I'm using Excel 2003 to keep track of grades in a college class that I teach. Each category of graded items has its own worksheet with all grade data for all students, and I have an Overview worksheet that calls up data from the other worksheets that tell me total items passed / points earned for all students.
I would like to create a worksheet that calls up data for just a single student, so that--when meeting with a student to discuss their grades--I can avoid revealing other students' grades, without having to clunkily do a split view, etc..
My plan: create a dropdown list of student names, then maybe?? use IF to generate a row of data. For example:
The dropdown list is named StudentName, and is available in worksheet SingleStudent. From this dropdown I select student "Doe, Jane" (Student names have spaces in them.)
Once I select a student name, I would like to have populated in that same worksheet columns B2:H2 with the data from the Overview worksheet row for Jane Doe, also in columns B to H.
Should I use an IF statement for this? (IF StudentName="X" THEN grab Overview!X??) How would I even write it? Any suggestions would be much appreciated.
I'm using Excel 2003 to keep track of grades in a college class that I teach. Each category of graded items has its own worksheet with all grade data for all students, and I have an Overview worksheet that calls up data from the other worksheets that tell me total items passed / points earned for all students.
I would like to create a worksheet that calls up data for just a single student, so that--when meeting with a student to discuss their grades--I can avoid revealing other students' grades, without having to clunkily do a split view, etc..
My plan: create a dropdown list of student names, then maybe?? use IF to generate a row of data. For example:
The dropdown list is named StudentName, and is available in worksheet SingleStudent. From this dropdown I select student "Doe, Jane" (Student names have spaces in them.)
Once I select a student name, I would like to have populated in that same worksheet columns B2:H2 with the data from the Overview worksheet row for Jane Doe, also in columns B to H.
Should I use an IF statement for this? (IF StudentName="X" THEN grab Overview!X??) How would I even write it? Any suggestions would be much appreciated.
