LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Subtotals and inserting formulae

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill formulae when inserting rows Riker1074 Excel Discussion (Misc queries) 9 December 30th 08 03:56 PM
Inserting worksheet makes formulae stop working Mark Excel Discussion (Misc queries) 5 April 24th 08 07:10 PM
Concerning subtotals and inserting jmcclain Excel Discussion (Misc queries) 8 February 12th 07 08:20 PM
Inserting new row but keeping formulae Alex Simpson Excel Worksheet Functions 0 August 8th 06 01:16 PM
inserting formulae [email protected] Excel Worksheet Functions 2 May 9th 06 02:08 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"