Hi rjennings,

See if the attached example workbook makes sense to you.

If you can make it work by hand then we can put some VBA behind the worksheets to do the Advanced Filter each time you click on a student worksheet.

Advanced Filter with DNR for Student Sheets.xlsx