P
paulfj
I have 1 worksheet (Attendance) that keeps track of attendance. Rows
10 - 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? I've seen similar questions,
but no answers. Also (and maybe most importantly), I'm designing this
form for 200 instructors to use - many of whom are not yet comfortable
with Excel. So I need to devise a solution (formula, macro, concise
set of steps, etc) for them to do this process.
I'll clarify more if needed, I don't want to further complicate the
situation by adding extraneous information.
Thanks for your help.
10 - 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? I've seen similar questions,
but no answers. Also (and maybe most importantly), I'm designing this
form for 200 instructors to use - many of whom are not yet comfortable
with Excel. So I need to devise a solution (formula, macro, concise
set of steps, etc) for them to do this process.
I'll clarify more if needed, I don't want to further complicate the
situation by adding extraneous information.
Thanks for your help.