?Tally chart using buttons???

[smithymcsmithy]

Hi everyone,

I am an excel newbie and struggling at the moment.

Im trying to create a tally chart using buttons on sheet 1. Each user clicks the button and is automatically counted on sheet 2. There are at least 10 buttons. I've included a sample excel for what I want. I need to log this by date, looking at a 7 day spread. Also if possible each time a button is clicked it saves automatically. This will have multiply users on a shared drive. Could someone explain this in newbie lingo to me

Any help would be greatly appreciated, thanks in advance.