Worksheet 1 has student ID's with the names in alpha order.
Worksheet 2 has students listed by class, with daily attendance columns that
adds up in a total column.

I need the attendance total column for each student, according to ID, on W2
to also appear in a totals column on W1 for the correct student.

So basically I need the totals column to match the student ID# on both
worksheets.

How do I do this?

thanks!