creating individual report cards (worksheets) based on template for report card

[TchrGrl]

I have two worksheets in my report cards:

1) Data – the students are listed in Column A, math scores in Column B, reading scores in Column C and science scores in Column D. The grades of 300 students are entered in this sheet.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Student[/TD]
[TD]Math[/TD]
[TD]Reading[/TD]
[TD]Science[/TD]
[/TR]
[TR]
[TD]Jimmy[/TD]
[TD]75[/TD]
[TD]84[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Sally[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Student 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


2) Report Card template – This is the report card that needs to be generated for each student. It’s pulling the student name and grades from the Data worksheet.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Student Name[/TD]
[TD]=Data!$A2[/TD]
[/TR]
[TR]
[TD]Math[/TD]
[TD]=Data!$B2[/TD]
[/TR]
[TR]
[TD]Reading[/TD]
[TD]=Data!$C2[/TD]
[/TR]
[TR]
[TD]Science[/TD]
[TD]=Data!$D2[/TD]
[/TR]
</tbody>[/TABLE]


How do I create worksheets (report cards) for additional students? I have 300 students in the school. I need the next worksheet to reference Data!$A3. I know how to cut and paste the report card template and then edit =Data!A2 to be =Data!A3 to create a report card for Sally. How do I create the 300 report cards I need?

I've been teaching for 13 years. I can create a report card for each student in my class and edit each worksheet individually for each student. Now I've been asked to do this for the whole school and I don't know how to create the other 299 sheets I need. Any help would be so greatly appreciated!! Thank you!

 

[ca.moazzam]

Hi there could be many options like 1) Having roll numbers of students on your data sheet, enter on the template sheet and results linked with that roll number using Vlookup etc. So when you change the roll number, result changes and you just print or 2) Make a pivot table and double click the roll number once which will make a separate sheet for each student. Which one you like?