Forum Discussion
Help with timesheet created by MS Forms
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):
What I am trying to do, is insert a row between Joe and Dave, then total Joe's hours and so on. I can do this manually easy enough, but I need it done in a macro. The row count will vary from week to week. Again, any help will be appreciated. TIA
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):
Many thanks HansVogelaar. That has worked perfectly. I had a few issues as the SubTotal option was grayed out, but found a solution on the web. Thanks again for your help.
Select the HOURS column.
On the Data tab of the ribbon, click Text to Columns, then click Finish without changing any settings.
Does that make Subtotal available?