linking worksheets in Excel 2007

[Millie]

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?

 

[trip_to_tokyo]

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.

 

[Millie]

Hi Perfect. But how did you link the two workseets? Can you guide me through
the steps?

 

[trip_to_tokyo]

Just look at the formulas in the cells; you should be OK from there.

 

[Millie]

Hi thanks. I understand now!
--
Millie

Just look at the formulas in the cells; you should be OK from there.

 

[trip_to_tokyo]

Wonderful.

If my commments have helped please hit Yes.

Thanks.