I have a lovely spreadsheet full of student data. The current format is quite simple: there are rows for student name, class, and individual marks for each part of the assignment.
I would like to use the data to populate a simple overview for each student. So once the teacher has input the marks for their class, they can run a macro (or something) and a cover sheet is produced for each pupil, with the variables filled in (their name, class, and the grades they got for each section of the exam).
Is this something I can do with Excel? Any advice appreciated.