Assigning points to multiple people in one row

[andrewb90]

I have a employee picnic and sports contest coming up and I am trying to figure out a scoring system to not only track a winner, but keep track of who was partnered with whom in which event.

I have a list of events/descriptions in column B. in each row there is a new event activity, juggling, 3 legged race, volleyball, etc... in column C&D I would want to put the two names of the people that were on the team, and E&F, G&H, etc. In my scoring sheet for individuals I would want to have a person's activities they participated in on their sheet as well as who they did the activity with.

So lets say Joey and Sara (not my real employees names) were in the three legged race. On my first sheet in the row for the race I would have Joey and Sara in the next two cells and beneath it would be the score they earned. (Column B4 would be merged with B5 and C4&D4 would say Joey and Sara respectively and C5&D5 would be merged to enter their score, Cells E&F and G&H would be the same as well.) Now on another sheet I would have participation results for 7 or 8 people and one of those people would be Joey. It would show what events Joey participated in and who his partner was, and how many points he had achieved.

I am thinking it would be easier just to type in the name of the people who participated in the event instead of finding each page and typing in the event and the person they completed it with.

I hope I made sense to somebody.

- Andrew