I'm relaying this message for a friend who does not have Usenet access.

He wants to use Excel as a database of members, the usual name, address,
tel, email, plus 'Team' and 'Points'.

This 'points' field contains the number of points that individual members
starts with and is then tied in with the 'Team' field so that if , say, the
'Red' team win 1 point he can somehow enter this somewhere on the page and
all Red team members will have 1 point added, it is also possible for them
to have a point deducted

In addition, each individual can also have points added or subtracted.
There will be a total of approx 200 members initially

How would he go about setting this up?
Any help appreciated

--
Ron