linking worksheets in Excel 2007
 

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

linking worksheets in Excel 2007
 

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.

linking worksheets in Excel 2007
 

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.

linking worksheets in Excel 2007
 

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.

linking worksheets in Excel 2007
 

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.

linking worksheets in Excel 2007
 

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.