I re-arranged your data, produced a pivot table and from that extracted data for the student listed in cell B1 of the Report Card worksheet. When you change the name, the grades for that name appear. The green tabs in the workbook are what I have done.
Bookmarks