I need an Excel or Google Sheet that will allow me to add classes and class members to one area and then allow me to note the date and time they attend classes.
The purpose is so I can track and see how many times a member has attended,
There are multiple classes, but only one class on at a time, so I see the "front" of the spreadsheet being a field that says "Select Class" and a drop-down appears that shows all the classes. I select a class and it then shows me an alphabetical list of members and I can hit a radio button to show they attended that class.
I would then press "submit" and the attendance would be noted and I would return to the "Front" of the spreadsheet ready for the next class.
Finally, I would need a reoprt tab where I could select a member and see what classes they attended in any specific date range. So a drop down, select the member, and then from a drop down the from and to dates for the range, and it would show how many classes they attended.