Thread: VBA sumif
View Single Post
 
Old 02-26-2016, 07:53 AM
Nisio07 Nisio07 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx sample vba subtotal.xlsx (13.3 KB, 17 views)
Reply With Quote