help need to total a months worth of worksheets into one report
 

everyday I enter the cheques we receive and all the relevant info about the
including what department bill it was to pay

I need to find a way create a Totals for the month" sheet, table, something
but I want it to be updated as I add the info to the daily worksheets

any suggestions?

help need to total a months worth of worksheets into one report
 

Instead of creating a separate worksheet for each day, store all the
data on one worksheet, and include a column for the date.

Then, use DataFilterAutoFilter to view the data for a specific day,
and use a pivot table to summarize the data.

Create a dynamic named range on the input sheet, and base the pivot
table on that, as described he

http://www.contextures.com/xlPivot01.html

As you add new rows to the table, they'll automatically be included when
you refresh the pivot table.


Cathi wrote:
everyday I enter the cheques we receive and all the relevant info about the
including what department bill it was to pay

I need to find a way create a Totals for the month" sheet, table, something
but I want it to be updated as I add the info to the daily worksheets

any suggestions?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html