| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotaling a Varied length Spreadsheet
I have a large Spreadsheet that is e-mailed to me every month that I break
down to arrive at certain totals. The column format remains the same every month and I was hoping for some help with a utility that could make my life easier. Column A of the Worksheet contains "Ledger Numbers," Column B contains a "Cost Code Identifier," Column C contains "# of Days," and Column D contains "Dollar Amounts." What I do every month is manually format the worksheet to sub-total by Ledger Number to obtain total days per ledger and total dollar amount per ledger. I also format the sheet to sub-total by Cost Code to obtain the number of days and the Dollar Amount per Cost Code. The Spreadsheet is already sorted by Ledger Number and the Amount of columns remains constant, but the Row length of the Spreadsheet Varies. For one month the 20 Ledger may be 100 rows long and the next month it may only be 80 Rows long. Any and all help is appreciated. Thanks Theo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtotaling a Varied length Spreadsheet
Just need to create a pivot table under the data menu.
An alternative would be to do Data=Subtotals. -- Regards, Tom Ogilvy "Theo Degr" wrote: I have a large Spreadsheet that is e-mailed to me every month that I break down to arrive at certain totals. The column format remains the same every month and I was hoping for some help with a utility that could make my life easier. Column A of the Worksheet contains "Ledger Numbers," Column B contains a "Cost Code Identifier," Column C contains "# of Days," and Column D contains "Dollar Amounts." What I do every month is manually format the worksheet to sub-total by Ledger Number to obtain total days per ledger and total dollar amount per ledger. I also format the sheet to sub-total by Cost Code to obtain the number of days and the Dollar Amount per Cost Code. The Spreadsheet is already sorted by Ledger Number and the Amount of columns remains constant, but the Row length of the Spreadsheet Varies. For one month the 20 Ledger may be 100 rows long and the next month it may only be 80 Rows long. Any and all help is appreciated. Thanks Theo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you create a chart with varied width and length? | Charts and Charting in Excel | |||
| cells of varied length extract last 3 digits | Excel Discussion (Misc queries) | |||
| clear all zero-length strings from spreadsheet? | Excel Discussion (Misc queries) | |||
| clear all zero-length strings from spreadsheet? | Excel Discussion (Misc queries) | |||
| clear all zero-length strings from spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
