View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PHisaw PHisaw is offline
external usenet poster
 
Posts: 24
Default Moving Subtotals

Is there a way to change where the subtotal is inserted when DataSubtotals
is selected for calculations? For example, I have a spreadsheet with the
following columns and it places a subtotal under jobs when they are counted
and under calcualted time when time is summed. I'd like for both to be under
the calculated time, if possible.

JobNumber Type Start Stop
Calculated
9999 xxx 1:00 2:00
1:00
9998 xxx 2:00 3:00
1:00
JobNumberTotal 2
JobNumberTotal
2:00

Would like it to be:

JobNumberTotal
2
JobNumberTotal
2:00

If anyone has any ideas to make this work without manually moving each cell,
it would be greatly appreciated!

Thanks,
Pam