Submit data at end of month so the values do not change when new month starts

[jamesraywebber]

I have a workbook called TSA Team Stats where on sheet "Monthly Stats" I have each month. Data is collected from Sheet2 on this sheet except the errors. I have the formula:

Please Login or Register  to view this content.

which shows how many errors they have for the current month. However when the month changes it will carry these numbers over to the next month on the "Monthly Stats" sheet. Is there a way that when the month changes, it submits the data to stay permanently & start counting on the next months range? I have included the workbook for your reference. I greatly appreciate any help given!