I am working on a VBA userform where technicians enter daily timesheets which gather time and other details such as (milage, meals, overnight). This info is written to a sheet which is used by accounts. (copy/sample attached)



The user has now returned asking to display a running total on the input screen. this running total will be based on date (column B) and category (Column C or column J) for column H and will display running total on time (both ordinary and o/vertime j= 1 and 2), meal (j = 3), milage (j=4), overnight (j=5).

I appreciate it involves group and or subtotal or most likely some form of a looped sumif but my brain is fried. Any help appreciated. Any further queries, please revert.

Many thanks.

Regards

Nisio

PS sub-totals can be written to new sheet if that makes things easier and I assume will be moved as file closes and re-generated as file opens an user has option to review and delete any previous entry.

Attached Files

sample vba subtotal.xlsx (13.3 KB, 15 views)