Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for cell to get information from other worksheets
simply reference a cell with the sheet id, such as
='Class 7A'!H10 If you do the summary of each class into cells on its own sheet, you can then pick up that summary directly on the master sheet, and do further aggregations there. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "new2excel" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't see cell information in excel but it is in the formula bar | Excel Discussion (Misc queries) | |||
Formula help on information sharing between 3 worksheets | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Using cell information in formula? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) |