does it need to be done via VBA? i'm sure i've done something similar using
a pivot table from the <Data menu button (which i guess could be refreshed
evey time it is acessed)



"Bill" wrote in message
...
Hello,
I have a file that contains reasons for errors in a process. Each row is
one error and contains info such as date, reason for error, etc. I would
like to be able to sum the number that occur per week and per month using
VBA code. Is there an easy way to do this? I have done it by adding a
week
number, month number and year number and summing, but that seems a little
long winded.

Thanks.

Bill