View Single Post
  #1   Report Post  
Carolly
 
Posts: n/a
Default Need Help linking worksheets

I recently took a part-time job as bookkeeper for an organization where I
need to be able to print a report on demand of current finances. I have a
workbook with 3 sheets. The first one is the General Ledger Report, 2nd,
receipts, and 3rd, lists the disbursements. My general ledger is: Begin.
Bal. plus Receipts minus Disburs, plus or minus transfers =ending balance.
The Ledger is listed by categories while the other two sheets are entered by
the date each action occurs. Although I have used Excel for some time, I have
only dealt with the simpler formulas and have never linked sheets together in
a workbook. Is it possible to link the receipts and disbursements to the
General Ledger so that every time I make an entry, it will reflect in my
General Ledger report? Any info will be appreciated. Using Excel 2003 SP1