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!