total to date

I prepare a monthly report of Firefighter's hours per day, fire calls per
day, medical calls per day, etc. AT the end of each month, I total each
indiviidual's numbers of hours worked, number of calls run, etc. How can I
then calculate totals-to-date from January's worksheet into February's
worksheet and so on throughout the year?

unless I am missing somthing, should it not be just a case of in Febs
sheet, having a formula like: =Sheet1!Cellref+Sheet2!Cellref, eg in the
cell you want the running total in feb to be as A1 for example, input a
formula like =Jan!A1(cell that total is in jan = A1 or
whatever)+Feb!A1?


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=512365