LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Formula for cell to get information from other worksheets

I am keeping track of our school's jog-a-thon with Excel. I have created a
workbook, where every worksheet is a classroom. At the bottom of each
worksheet I have a cell that has a formula adds all the money up for that
class.

The last worksheet page is a totals page. What formula do I put in the
cells to get the information from the other worksheet pages? Is there a
formula that I can put in there, so that it will update when we enter new
information in the worksheet pages?
 
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
Can't see cell information in excel but it is in the formula bar MPTL06 Excel Discussion (Misc queries) 5 January 12th 07 05:10 PM
Formula help on information sharing between 3 worksheets Macmo Excel Discussion (Misc queries) 7 May 13th 06 04:50 PM
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? Marc New Users to Excel 1 March 10th 06 05:10 PM
Using cell information in formula? Gruben Excel Worksheet Functions 1 October 20th 05 11:52 AM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM


All times are GMT +1. The time now is 02:06 AM.

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"