| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you tie in balances into 1 master sheet on excel
in excel, I have various sheets with balances. How do I create a formula
that will tie the various sheets into one master sheet instead of having to go back and forth bewteen my master sheet and individuals sheets repeating the formula for each individual sheet. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you tie in balances into 1 master sheet on excel
Hi,
1. The easiest way is to move to the Master sheet, select a cell where you want the data from one sheet to appear 2. Type = 3. Click on the sheet tab that your data is in , then click on the cell you want and press Enter. -- Thanks, Shane Devenshire "traci" wrote: in excel, I have various sheets with balances. How do I create a formula that will tie the various sheets into one master sheet instead of having to go back and forth bewteen my master sheet and individuals sheets repeating the formula for each individual sheet. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you tie in balances into 1 master sheet on excel
Are the balances on each sheet in the same cell?
=SUM(Sheet2:Sheet12!F34) entered in a cell on Sheet1 Gord Dibben MS Excel MVP On Mon, 29 Sep 2008 14:05:01 -0700, traci wrote: in excel, I have various sheets with balances. How do I create a formula that will tie the various sheets into one master sheet instead of having to go back and forth bewteen my master sheet and individuals sheets repeating the formula for each individual sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching and returning values to a master sheet in Excel 2007 | Excel Worksheet Functions | |||
| how do i transfer necessary rows/data from a master excel sheet | Excel Worksheet Functions | |||
| Automatically add records from a new sheet to master sheet | Excel Discussion (Misc queries) | |||
| Master Sheet | Excel Worksheet Functions | |||
| How to link endings balances to beginning balances on different sh | Excel Worksheet Functions | |||
Linear Mode
