On my sheet I have my employees & I have a weekly & monthly stats sheet with the yearly on Sheet2. On the Control sheet I have 3 buttons, basically I want to press Submit Daily stats where it will popup with a form, then it will basically put the values in on sheet 2 for the person it is beside.
I have the weekly stats dates to update based off the beginning of the week. I want it to look up all the values based off sheet 2 along with the employees personal sheet and update the values.
Here is the catch, at the end of the month, I want all the employees values to clear because the date will switch to a new month at the end of the month. Can anyone please assist me with this?
On another button, I want it to email the weekly stats along with the monthly stats for that particular month. What I currently have, it only emails the weekly stats, however i need it to find the currently monthly stats off the "monthly stats" sheet & copy that into the email as well. I have attached my sheet for your assistance!
Bookmarks