Monthly bank stmts

[KathyT]

I have a workbook for each month of the year to track daily receipts and
expenses. There can be mulitple rows for a day. How do I carry the ending
balance from one month (worksheet) to the beginning balance of another
(worksheet)?

 

[Peo Sjoblom]

Assume ending balance is in H30, assume the sheets are named like Jan06,
Feb06 and so on, so for
ending balance of Jan06 as beginning balance of Feb06

='Jan06'!H30

easiest way is to select the cell in Feb06+ where you want the beginning
balance
type =
select Jan06 with the mouse, select H30 and press enter


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Michael M]

Hi Kathy
If your last entry for example is on sheet 1 cell d52
on sheet 2 in your first balance cell put
=Sheet1!D52

HTH
Michael M

 

[KathyT]

thanks. Is there a formula that will pull the last figure for the month and
insert it into the next month's worksheet? I'm trying to avoid adding a new
formula each month.

 

[bony_tony]

The formula quoted will pull the figure out from the last day of the
previous month, it will change when the previous month's figure
changes, so it will not need to be re-entered each month

Tony

 

[Martin Fishlock]

Hi Kathy:

I assumed that in cell B2 there is the month
and in cell B3 there is the year

on feb06 sheet in the cell where the b/fwd is:

=INDIRECT(TEXT(DATEVALUE("1/"&$B$2&"/"&B3)-1,"Mmmyy")&"!H30")

If as you say the total varies then you can use a vlookup with some unique key

say in column A on the last line is "Total for the month"

Then
=VLOOKUP("Total for the
month",OFFSET(INDIRECT(TEXT(DATEVALUE("1/"&$B$2&"/"&$B$3)-1,"Mmmyy")&"!a1"),0,0,5000,8),8,FALSE)

This even works for the first month of the year if the are the previous
years worksheets in the same book.