Re: Trans****ting sum from one sheet to another sheet in same workbook
by JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED]
>
May 11, 2008 at 04:01 PM
In article <ee9b147.-1@[EMAIL PROTECTED]
>,
Bourbon@[EMAIL PROTECTED]
wrote:
> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
>
> How do I trans****t the sum (from one cell) of one sheet to another sheet
in
> same workbook. i.e. Workbook called "Budget". Within the Budget Workbook
> there are several sheets entitled, e.g. "Housing"; "Personal"; "Pet
> Expenses"; "Medical Expenses" etc. I would like to trans****t each of the
> total expenses in a separate sheet within the same workbook called
"Budget
> Summary" . The grand total of all expenses can then be made on the
Summary
> Budget sheet.
One way:
On a cell in sheet Summary Budget (where total cell in sheet "Housing"
is J10):
=Housing!J10
