Here's my problem:

I have a excel check sheet with two columns (1 for apprvoved, 1 for not approved) each cell in these columns has a check box linked to it. I also have a date and a time control on the page.

I have made a control button that when clicked I would like copy all the checked boxes (true cells) and paste a running tally of them on another page.

I then want it to save only the sheet where the data was recorded in a folder with the name of the sheet followed by the date and time entered in those controls.

Finally the macro should clear the check boxes save the "template workbook" and close.

My VBA skills are rusty at best so I'm not sure how to even begin this.

Any help???
Thanks