karthikvlsi
New member
- Joined
- Sep 25, 2012
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Hello Friends,
i am having one doubt for displaying students grade from one sheet to another.i just started to create one excel sheet for engg students grade analysis.in that after entering all the students grade for one particular semester,if one particular student is asking his mark statement means how can i display the grade for the particular student by comparing his register no or roll no in another sheet.if i am changing register no or roll no means for that particular register no or roll no i need that student grade.
herewith i attached my excel sheet.
In I YEAR sheet for example i am having two students i sem results,if any one the student is asking his mark statement for first sem means.Now i want to take printout using the sheet STAT.In that if i entered any one the student roll no means i got formulas for displaying his register no,name automatically which roll no we entered.Now i need to display his first sem marks as we entered in sheet I YEAR for a particular student who's roll no what we entered in sheet STAT,this will continue for N no of students.
i am having one doubt for displaying students grade from one sheet to another.i just started to create one excel sheet for engg students grade analysis.in that after entering all the students grade for one particular semester,if one particular student is asking his mark statement means how can i display the grade for the particular student by comparing his register no or roll no in another sheet.if i am changing register no or roll no means for that particular register no or roll no i need that student grade.
herewith i attached my excel sheet.
In I YEAR sheet for example i am having two students i sem results,if any one the student is asking his mark statement for first sem means.Now i want to take printout using the sheet STAT.In that if i entered any one the student roll no means i got formulas for displaying his register no,name automatically which roll no we entered.Now i need to display his first sem marks as we entered in sheet I YEAR for a particular student who's roll no what we entered in sheet STAT,this will continue for N no of students.