VBA sumif
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.
|