Help with Accumulating totals for different Months

  • Thread starter Thread starter krislyn
  • Start date Start date
K

krislyn

Have a spreadsheet where each worsheet is a different job duty. Each jo
is checked for errors. Date being checked, # of items checked, Numbe
of Errs and #of items correct are logged then worksheet is blanked fo
the next date to check.
On any given day one job may be checked for 11/2 another job may b
checked
for 10/29. Need to move totals for each worksheet into a total shee
that lists Jan-Dec. Need each worksheet to move to the correct month
plus add the current amount to any previous total that may already b
there for that month?

Ex for each worksheet:
Cell a1=Date
Cell a2=# of items checked
Cell a3=number of errors
Cell a4=number of items correct

Need to accumulate above into Totals worksheet:

Column A Column B Column C Column D
January #checked # of Errs # Correct
February #checked # of Errs # Correct
March #checked # of Errs # Correct
and so on.

My knowledge is basic, so bear with me if I ask alot of questions
Thanks in advance for your time and help!
Krisly
 
No, a Pivot table uses a list to sort and sum. My data will be entere
into the same cell then blanked out when that day is done. So th
numbers need to be "moved" and added to a worksheet that holds an
previous total for that month. I need help with a macro that will mov
and accumulate the # of items for each category. :confused
 
Back
Top