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

Occasional Visitor

Hello, 

 

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. 

 

Thanks! 

0 Replies