V
veganfury
I am working on a grade/attendance program for a teacher friend. Fo
each class there are 3 worksheets. "Class 1" allows the teacher t
enter students names as well as assignment scores. "Attendance 1
automatically imports the student names from "Class 1" allowing th
teacher to track attendance. The last worksheet is "Reports 1" whic
allows the teacher to prepare individualized reports on each student.
I want to allow the teacher to sort the student list from "Class 1" t
be alphabetical and then update the "Attendance 1" list and mov
attendance data for each name to corespond to the the correct student.
I thought I could simply copy the "Attendance 1" data with a macro an
then sort it and post it back in to the table. When I do this thoug
the copying includes unused cells and sorts them above the alphabetica
data and then would not match with the sorted list from the "Class 1
tab.
I am including a *.zip file of the excel program I am working on if i
helps. If any of the worksheets are still protected, the password i
"nadja".
thanks for everyone's help
Mat
+-------------------------------------------------------------------
|Filename: supersort attempt.zip
|Download: http://www.excelforum.com/attachment.php?postid=2695
+-------------------------------------------------------------------
each class there are 3 worksheets. "Class 1" allows the teacher t
enter students names as well as assignment scores. "Attendance 1
automatically imports the student names from "Class 1" allowing th
teacher to track attendance. The last worksheet is "Reports 1" whic
allows the teacher to prepare individualized reports on each student.
I want to allow the teacher to sort the student list from "Class 1" t
be alphabetical and then update the "Attendance 1" list and mov
attendance data for each name to corespond to the the correct student.
I thought I could simply copy the "Attendance 1" data with a macro an
then sort it and post it back in to the table. When I do this thoug
the copying includes unused cells and sorts them above the alphabetica
data and then would not match with the sorted list from the "Class 1
tab.
I am including a *.zip file of the excel program I am working on if i
helps. If any of the worksheets are still protected, the password i
"nadja".
thanks for everyone's help
Mat
+-------------------------------------------------------------------
|Filename: supersort attempt.zip
|Download: http://www.excelforum.com/attachment.php?postid=2695
+-------------------------------------------------------------------