Hey!
I am a teacher and I use excel to generate my grades.
Now I have a workbook with about 6 worksheets; one for each subject.
So each worksheet has grades for about 40 students for that one particular subject.

Is it possible to generate individual report cards for the students with grades of all their subjects AUTOMATICALLY?

I have been trying to find a solution for a very long time but just can't figure out a way to work this out..

Please help me out!!!!

Thanks..