Tom Ogilvy wrote

For the second range, I
have left in the Range("Attendance") part, but clearly that would not
correspond to the second set of data,

Well, when I choose "Attendance" from the Name box, the range for the
currently selected sheet is highlighted. IOW range depends on which sheet
I'm viewing even though "Attendance" is only listed once. So I think any
routine would grab the correct range for the referenced sheet.

--
David