How can I sort a worksheet and have data on a linked worksheet update?
Here's my situation:

I have 1 worksheet (Attendance) that keeps track of attendance. Rows
11 - 37 (27 students) with columns J - DQ for recording daily
attendance.

I'm designing a 2nd worksheet (Progress) in the same workbook to keep
track of progress.

Currently, the student names on Progress are linked to those on
Attendance. This works fine. However, when I sort Attendance, only
the student names on Progress move causing information on this second
sheet to no longer correspond to the correct student.

Is there a way to sort Attendance and have the data I enter on Progress
stay with the names they're supposed to?

Thanks for your help.