close

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: www.excelforum.com/member.php...oamp;userid=19492
View this thread: www.excelforum.com/showthread...hreadid=512365

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()