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

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