Hi there,

Say for example you wanted to add the contents of cell A1 in each of the 3
worksheets all you do is enter the equal sign = and then click cell A1 in the
first sheet, enter the + sign, then click cell A1 in the second sheet, +,
cell A1 in the third sheet. Then press enter when you have finshed and it
will add the contents of all three cells in each work sheet.

To use a cell in a different sheet to the one you are in you just goto that
sheet and select it.

Hope that helps,

Naz,
London



"Carolly" wrote:

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