Hi
A friend of mine asked me if I could help him around with following case.
He's in a card club and they have about + 30 members.
Members join beginning of January and play for a complete year. The play once a month cards together and he notes down all the scores. Every month they rank the best player and the person who wins the most is at the end the champion.
Now I can easily create a sheet that does following:
But I would like to avoid to recreate every year this table and I'm trying to find a way to automate all the participants and date to automatically create beginning of the year.
So he only needs to maintain 1 list of participants and automatically everything gets generated, but I wan't to avoid VBA.
The person isn't a Excel expert, so I really want to keep it simple, but I'm lost in my design idea.
Any ideas how I could start with this?
Off course I'll add validation and list where possible so the error margin is reduced to almost none
Thank you for the feedback
A friend of mine asked me if I could help him around with following case.
He's in a card club and they have about + 30 members.
Members join beginning of January and play for a complete year. The play once a month cards together and he notes down all the scores. Every month they rank the best player and the person who wins the most is at the end the champion.
Now I can easily create a sheet that does following:
Name | Month | Games won | Points |
John | jan | 3 | 450 |
Will | jan | 2 | 400 |
Gloria | jan | 1 | 360 |
John | feb | 1 | 200 |
Will | jan | 1 | 320 |
... | ... | ... | ... |
John | dec | 1 | 100 |
But I would like to avoid to recreate every year this table and I'm trying to find a way to automate all the participants and date to automatically create beginning of the year.
So he only needs to maintain 1 list of participants and automatically everything gets generated, but I wan't to avoid VBA.
The person isn't a Excel expert, so I really want to keep it simple, but I'm lost in my design idea.
Any ideas how I could start with this?
Off course I'll add validation and list where possible so the error margin is reduced to almost none
Thank you for the feedback