setting up Lottery Syndicate

Can anyone help me on how i could use excel to run a Lottery Syndicate ???

Do you want a spredsheet that will check all members numbers against winning numbers and give the amount of matches?
If so I have a ready made checker

Yes something like that, but also where i could keep a record of money paid etc

I WOULD LIKE A FORM TO SET UP A SYNDICATE OF PLAYERS AT WORK FOR WHEN WE DO
THE EURO MILLIONS