Find a student's 3 lowest scoring tests

Hello VBA pro's,

I have attached a workbook that shows what I would like to do.

I am a teacher and use excel as my grade book. The grade book will contain 30 to 40 tests (I only did 10ish on the example worksheet) in columns with student names in the corresponding rows. I would like to write a VBA subroutine that scans each student's scores (in the rows) and then reports to me what their 3 lowest tests are (not the scores themselves but the testnames). These testnames will then be returned to a separate range like the one in the middle of the sheet.


Thank you in advanced for your help.