| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 switching ifo from one sheet to another
how do i take a sum that has been calculated on sheet 2 and automatically
have it trannsferred to a designated cell on sheet 1? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2003 switching ifo from one sheet to another
Move to the cell in sheet one where you want to place the sum reference and
do the following: Type an = sign Press Ctrl + PgUp to move to sheet2 Click the cell with the sum Press Enter to complete the formula Or you can type the entire formula by entering the name of the worksheet, enclosed in single quotes, followed by the cell address that has the sum formula. See example below: ='Sheet2'!D52 -- Kevin Backmann "jmh" wrote: how do i take a sum that has been calculated on sheet 2 and automatically have it trannsferred to a designated cell on sheet 1? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2003 switching ifo from one sheet to another
"jmh" wrote: how do i take a sum that has been calculated on sheet 2 and automatically have it trannsferred to a designated cell on sheet 1? thanks that works for me jmh |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2003 switching ifo from one sheet to another
"Kevin B" wrote: Move to the cell in sheet one where you want to place the sum reference and do the following: Type an = sign Press Ctrl + PgUp to move to sheet2 Click the cell with the sum Press Enter to complete the formula Or you can type the entire formula by entering the name of the worksheet, enclosed in single quotes, followed by the cell address that has the sum formula. See example below: ='Sheet2'!D52 -- Kevin Backmann thank you jmh "jmh" wrote: how do i take a sum that has been calculated on sheet 2 and automatically have it trannsferred to a designated cell on sheet 1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switching printes in Excel | Setting up and Configuration of Excel | |||
| Excel 2003 sheet name | Excel Discussion (Misc queries) | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
| Macro error after switching from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) | |||
| problems switching speadsheets in excel 2000 using windows xp | Excel Discussion (Misc queries) | |||
Linear Mode
