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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"KathyT" wrote:

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.

"Peo Sjoblom" wrote:

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)


"KathyT" wrote in message
...
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)?