summarizing all spreadsheets in a workbook
Posted by Tove on August 30, 2001 11:20 AM
I want to create a cover worksheet of sorts that automatically fills in totals (which have been created with formulaic cells using the SUM function), from all other spreadsheets in the document. The data I want to copy is located in the same cell positions in all spreadsheets, if that makes it any easier.... There are, however, varying numbers of spreadsheets whose information needs to be compiled; anywhere from 1 tab to 5 tabs. Please help!
Posted by Bryan on August 30, 2001 4:20 PM
Insert a blank worksheet immediately before the first sheet to be summed and name it "Start".
Insert another blank worksheet immediately after the last sheet to be summed and name it "End".
In your summary sheet use the following formula format :-
=SUM('Start:End'!A1)
Sheets can then be inserted or deleted between the "Start" and "End" sheets and the sum formulas will not be affected.
