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 |
All times are GMT +1. The time now is 06:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com