Is there a way of mail merging and filling in multiple fields across sheets?

Occasional Visitor



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. 



0 Replies