financial workbook

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
 
C

Charlie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carry over YTD balance to next worksheet 4
Counting dates with specific criteria 1
YTD SUMIF based on current date 3
Copy/ move selected data from workbooks to seperate worksheets or workbooks 1
Create different workbooks from workbooks 3
Counting multiple occcurrences between date range 3
Sumproduct giving #Value error 5
frustraded with conditional values return in a range of dates 1

Top