Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default 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.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
An error msg in Excel 2007 regarding Linking but no linking in fil Jugglertwo Excel Discussion (Misc queries) 0 September 12th 08 02:08 AM
Linking Excel 2007 to Powerpoint 2007 Russ Links and Linking in Excel 0 June 24th 08 02:14 PM
Linking Form to worksheets excel 2007 JWster Excel Discussion (Misc queries) 0 October 12th 07 06:55 PM
worksheets linking in Excel? 703 Excel Worksheet Functions 1 August 25th 06 06:48 AM
Linking Excel Worksheets GLT New Users to Excel 6 October 27th 05 03:57 PM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"