Merging worksheets

[cmack]

How can I compile data from several worksheets into one? In other words what
I am asking is how can I take information from different sheets and combine
the total on one sheet. Example:

Sheet 1 thru Sheet 7 all have the same data, but different totals how can I
get another sheet that will show a running total of all sheets?

Colum H
2.00
3.00 All sheets have this column.
28.00

On the last column I need a running tabulation of any amount that is added
on the other sheets.

Thanks

 

[Max]

Assuming the 7 tabs: Sheet1, Sheet2, ... Sheet7
are placed such that Sheet1 is leftmost and Sheet7 is rightmost
(the rest of the 5 sheets can be placed in any order in-between)

Assuming the total in each of the 7 tabs is calculated in H20
Then in your summary sheet,
(which must be placed outside of the group of 7 tabs above)
you could simply use: =SUM(Sheet1:Sheet7!H20)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik