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?

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?

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

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?