Data from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving values from another sheet 1
Pivot from multiple sheets 1
Average of Subtotals in Pivot Table 0
Move data from one worksheet to another. 1
Adding totals to new sheet 9
transferring total sheet from one workbook to another 3
WORKSHEET INSIDE A WORK BOOK 1
Time Sheet Summary 1

Back
Top