Need formula
Where does the $150 come from?
It would be something like
=the_150_cell+SUM(Sheet1!A:A)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"George" wrote in message
...
I am working on a financial workbook in excel. How can I link data between
sheets in a workbook? When entering data in one sheet, I want it to auto
update in another sheet in the same workbook. Here is a example wheat I
want to do......
A1 Household
A2 $50 this is on one sheet and on another sheet I have.....
Total Household Expenses: $150
When I enter the $50 in the first sheet, I want the second sheet to be
updated with the $50 in "Total Household Expenses" which should change to
$200
Thanks!
|