Club membership attendance

MarkBarnes

New Member
Joined
Dec 3, 2016
Messages
1
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,
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
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,
 

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,812
Members
416,884
Latest member
leeshjay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top