financial workbook

  • Thread starter Thread starter cathyp
  • Start date Start date
C

cathyp

I am trying to update a financial "workbook". There is a column fo
checks written that will go automatically to the column in a seperat
financial report worksheet. The problem is there is a new workshee
for each month. I need to carry the balance from each line item in th
previous month into the current month. Is there a formula for this o
do I just need to put those totals in myself? Thanks for any help
 
One way would be.

If your line item for March is in cell J3 of the 'Mar 04'
tab then in the 'Apr 04' tab enter ='Mar 04'!$J3 in which
ever cell you want the calculation, and copy down. The J3
portion of the formula will change to J4 then J5 and so on.

For the May 04 tab use ='Apr 04'!$J3 and so on.

Hope it helps.

Charlie O'Neill
 
Back
Top