I currently have a spreadsheet that tracks employee errors. I have employee
names accross the top in row 1 and a list of types of errors going down in
collum A. I put how many errors they made of each type in each persons
collum. I have each week on its own worksheet tab. I then have one more
worksheet that gives me totals and averages taken from the previous weekly
worksheets. This works great. I have only done this for one month. I now
need to start with one for this month, which will have a new total/average
sheet (I track each month seperatly). What would the best/easiest way to set
this up be? Each worksheet is named for the week (Aug 8-Aug12, etc) so they
will change each week. Is there anyway i can set this up so i am not having
to redo all of the functions on the total's page each month?