Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings!
I am mooking for some code/advice on inserting code into the subtotal rows created by SUBTOTAL. Is there a way to autofill the formulae in the rows created by the function (the subtotal and Grand Total rows)? I work for a human services agency that tracks time spent with clients in 15 minute increments rounded to the next integer. Subtotal is a great way to quickly sort and add these minutes together, but it cannot be expected that the end users will be able to autofill formulae correctly. I am looking for a way to insert some code that will sum the time units rather than the minutes on the Grand Total row . Being as there are different numbers of clients seen by each case manager on a day-to-day basis (resulting in a variable number of rows filled out on the worksheet), it would be ideal to find a way to insert a function in the last row created by Subtotal. I hope this made sense. Thanking you in advance, -alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto fill formulae when inserting rows | Excel Discussion (Misc queries) | |||
Inserting worksheet makes formulae stop working | Excel Discussion (Misc queries) | |||
Concerning subtotals and inserting | Excel Discussion (Misc queries) | |||
Inserting new row but keeping formulae | Excel Worksheet Functions | |||
inserting formulae | Excel Worksheet Functions |