Microsoft Excel

L

Laurie

Can I create a summary worksheet in a workbook that contains totals from each
worksheet in that workbook.
 
C

CLR

Yes,
This formula in any cell in Sheet1 will return the value in Cell D1 of Sheet2
=Sheet2!D1

Likewise, this one will return the value in cell G7 of Sheet3, etc etc
=Sheet3!G7

hth
Vaya con Dios,
Chuck, CABGx3
 
Top