| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - How do I make a cell calculate from another page or tab
I have a Workbook "IFTA FUEL TAX FORM" with several named tabs in it. I am
trying to make the tabs calculate between each other. For instance Page1, & Page2, tabs will calculate the results from the Mileage and Fuel tab. Page 3 will calculate the "totals" cell from Page1 & Page 2 tabs. What formula language do I use to reference between the tabs? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - How do I make a cell calculate from another page or tab
Sheet names are written before cell reference, followed by an exclamation
mark. If there is a space in sheet name, inclose in single quotes. Examples: =SUM('My Sheet'!A2:A100) =LOOKUP(A2,Sheet2!B2:C100) Note also that if you type "=" into a cell, you can then navigate to another sheet tab, and the formula will write the reference for you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mitch Harrison" wrote: I have a Workbook "IFTA FUEL TAX FORM" with several named tabs in it. I am trying to make the tabs calculate between each other. For instance Page1, & Page2, tabs will calculate the results from the Mileage and Fuel tab. Page 3 will calculate the "totals" cell from Page1 & Page 2 tabs. What formula language do I use to reference between the tabs? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a cell calculate percentages of another cell. | Excel Discussion (Misc queries) | |||
| How to make each cell in Excel worth a page? | Excel Discussion (Misc queries) | |||
| How do I make a header row appear at top of each page (not cell#) | Excel Discussion (Misc queries) | |||
| How do I make the D.O.B. Column calculate in Age Colum in Excel? | Excel Worksheet Functions | |||
| can you make a title page using Excel? | Excel Worksheet Functions | |||
Hybrid Mode
