.. The only outstanding question I have now is how to duplicate the
information entered into columns F to AJ on the residents tab to the columns
C to AG in the activity summary tab. In other words, when the residents names
are summarized on the activities tab for each of the activities they
participated in, how do I get their participation information to fill in too?
...

In Activity Summary,

Array-enter in C7 (press CTRL+SHIFT+ENTER):
=IF(OR($AH$3="",$A7=""),"",INDEX(Residents!F$13:F$ 67,MATCH(1,(Residents!$A$13:$A$67=$AH$3)*(Resident s!$B$13:$B$67=$A7),0)))
then copy C7 across to AG7 and fill down

Repeat the construct similarly for the other codes. Copy C7 n paste into the
next top left corner cell, ie C21, then change AH3 to AH17, array-enter it,
then copy across/fill down. Repeat for C35, and so on.

I've sent over an implemented construct for the above.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mcilwrk" wrote:
Thanks for your help Max. Sorry I replied to your email before reading the
request to post all follow-up questions in the newsgroup....

As a follow up, there are 31 columns representing every day of the month.
What code would I need to use to duplicate that daily participation
information for each resident from the residents tab over to the activities
tab where it summarizes which resident participated in which activity during
the month.?

It is so difficult to explain what I am trying to do without being able to
see the spreadsheet.

Thanks again for your input
--
Ken McI