Forum Discussion
Solved
Help with timesheet created by MS Forms
Hi Folks, new to this forum so please be gentle 🙂 I have 8 employees who use a mS Form I have created to input their weekly timesheet. At the end of the week, I save the results to an excel file...
You can use Excel's Subtotal feature.
Click anywhere in the data.
Activate the Data tab of the ribbon and click Subtotal in the Outline group:
The Subtotal should propose to add a subtotal for each change in the NAME column, and add it to the HOURS column:
Click OK. Result (with some random dummy data):
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Please see above. This is what I get from the form after I remove the columns I dont need and sort the order of the day of the week and then the employees. The number of rows can vary from week to week. What I am looking for is a way to add up the hours of each employees. Ideally I would insert a row between each employee the total the hours for each employee. It needs to be done in a macro. TIA.
What do you mean by "Please see above"?
Sorry HansVogelaar I thought I had attached a screenshot. I will try again tomorrow when I have more time.