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

[Guest]

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]

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 Data>Filter>AutoFilter 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 here:

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.