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?
|