Form submit button Help

I have a user form in VBA that pops up when I hit submit daily stats. I want to hit submit in that form and post. When I press submit in the form, I want those totals to add to the name that is beside the boxes (sheet name is their names) and add the info based of the date of Today(). Can you please help!? I have attached the workbook for your help.

Example: So if beside Ray Webber, I put 5 in emails touched & 7.5 in hours worked, when I press submit, in cell C38 on sheet2 should have 5 and in cell C40 should be 7.5. However, it would need to go into the cell that is equal to todays date which is located in row 4. Any help would be greatly appreciated!

How about

Please Login or Register  to view this content.

Thank you so much - that works perfectly!!!

Glad to help & thanks for the feedback

Thank you so much - that works perfectly!!!

One more question - so I have changed the cell value in Cells A4 on everyone's sheet so it calculates the date based off the month. Meaning each month, those dates will change. Is there a way that once the date changes, it will keep the monthly stats for January and start adding the numbers in the February monthly stats?

I also need a button so that when i click on it to export all the sheets with everyone's name on it into another workbook and save it as the monthly data?

Don't quite follow, what you're after.
How are the individual sheets getting updated?
The code I supplied is adding the data to Sheet2, rather than the individual sheets.

Correct, so I have the info pulling from sheet 2 & from the data source to update the personal monthly stats. I basically want a button that I can press & it will export all the sheets that has their names on them saved in one workbook and save it to a location. Also is it possible to have it email out each sheet to that person's email with one button press?

Try

Please Login or Register  to view this content.

Change path & filename to suit.