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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top