Data from one sheet to another
 

My xls file has 5 sheets, the fifth on is totals. How do I bring over the
totals from the other sheets for a grand total on sheet 5?

Thanks.

Data from one sheet to another
 

If the sheets are all structured IDENTICALLY, you could use '3D sums' to do
the job. Ex: click in Sheet5, cell B2. Type =SUM( then click in Sheet1,
cell B2, then shift-click on the tab for Sheet4 and finally hit enter. Your
formula will read =sum(sheet1:sheet4!B2). You can autofill that formula
across and down to pick up all the sums. (You'll probably want to first copy
one of your other sheets to get all the labels, formats, etc).
If the sheets aren't structured identically, you'll have to create all the
equations: =sheet1!a2+sheet2!a3+ ....
--Bruce

"rml" wrote:

My xls file has 5 sheets, the fifth on is totals. How do I bring over the
totals from the other sheets for a grand total on sheet 5?

Thanks.