Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I can do basic formulas in Excel 2007 like adding subtracting etc. Here's what I want to do and I would appreciate any help in achievingit: In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. Can anyone help? -- Millie |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
EXCEL 2007
I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 106. This is one way in which you might do it. If you add in extra items into Money_Spent columns A and B you will see what you have got left in Budget cell C2. If my comments have helped please hit Yes. Thanks. In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Perfect. But how did you link the two workseets? Can you guide me through
the steps? -- Millie "trip_to_tokyo" wrote: EXCEL 2007 I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 106. This is one way in which you might do it. If you add in extra items into Money_Spent columns A and B you will see what you have got left in Budget cell C2. If my comments have helped please hit Yes. Thanks. In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just look at the formulas in the cells; you should be OK from there.
"Millie" wrote: Hi Perfect. But how did you link the two workseets? Can you guide me through the steps? -- Millie "trip_to_tokyo" wrote: EXCEL 2007 I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 106. This is one way in which you might do it. If you add in extra items into Money_Spent columns A and B you will see what you have got left in Budget cell C2. If my comments have helped please hit Yes. Thanks. In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi thanks. I understand now!
-- Millie "trip_to_tokyo" wrote: Just look at the formulas in the cells; you should be OK from there. "Millie" wrote: Hi Perfect. But how did you link the two workseets? Can you guide me through the steps? -- Millie "trip_to_tokyo" wrote: EXCEL 2007 I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 106. This is one way in which you might do it. If you add in extra items into Money_Spent columns A and B you will see what you have got left in Budget cell C2. If my comments have helped please hit Yes. Thanks. In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Wonderful.
If my commments have helped please hit Yes. Thanks. "Millie" wrote: Hi thanks. I understand now! -- Millie "trip_to_tokyo" wrote: Just look at the formulas in the cells; you should be OK from there. "Millie" wrote: Hi Perfect. But how did you link the two workseets? Can you guide me through the steps? -- Millie "trip_to_tokyo" wrote: EXCEL 2007 I have just put up a file for you at:- http://www.pierrefondes.com/ Item number 106. This is one way in which you might do it. If you add in extra items into Money_Spent columns A and B you will see what you have got left in Budget cell C2. If my comments have helped please hit Yes. Thanks. In worksheet 1, I want to add up money i spend. In worksheet 2, i want to show my budget total and then see the reducing total as I enter amounts in worksheet 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
Linking Excel 2007 to Powerpoint 2007 | Links and Linking in Excel | |||
Linking Form to worksheets excel 2007 | Excel Discussion (Misc queries) | |||
worksheets linking in Excel? | Excel Worksheet Functions | |||
Linking Excel Worksheets | New Users to Excel |