View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default Monthly bank stmts

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