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)?