Club membership attendance

[MarkBarnes]

I would like if possible to create a spreadsheet/form to manage attendee and finances at a club, what i would like to have is a sheet with all the club members on, then on subsequent sheets would be the days the club is open, on the new sheet i would then set the price of entry for that day (entry price will be either £3 or £5 depending on session type), i would then like to have a data entry feild that i could type the members name it would then add them to the sheet for that day, whilst putting there entry price both on the first sheet with there details (so it shows what sessions they have attended) and onto another sheet so i could have an overview of the clubs finances, i would like then to be able to copy the sheets/formulas to cover multiple days over the year,

 

[tusharm]

May I suggest a simpler UI?

Put the names down column A. Then, at the top of each of column B, C, etc., enter the date of the meeting and the price for the day. Then for each member a 1 in that column would indicate attendance (easily extended to guests by entering a number greater than 1, e.g., 3 to indicate 2 guests?)

I would like if possible to create a spreadsheet/form to manage attendee and finances at a club, what i would like to have is a sheet with all the club members on, then on subsequent sheets would be the days the club is open, on the new sheet i would then set the price of entry for that day (entry price will be either £3 or £5 depending on session type), i would then like to have a data entry feild that i could type the members name it would then add them to the sheet for that day, whilst putting there entry price both on the first sheet with there details (so it shows what sessions they have attended) and onto another sheet so i could have an overview of the clubs finances, i would like then to be able to copy the sheets/formulas to cover multiple days over the year,