Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
A totalled Spreadsheet from an existing spreadsheet.
Posted by Eric Metoyer on February 08, 2002 11:01 AM
I am not that computer literate so forgive me. However, I am trying to create a spread shet that totals in the same cell the sum of all spread sheets in the entire documents. You send me a formula.
| Check out our Excel Resources
|
 |
 |
Re: A totalled Spreadsheet from an existing spreadsheet.
Posted by XLmon on February 08, 2002 11:15 AM
to sum all the values in cell B2 of sheets 2 thru 10, in sheet1 cell B2 put: =SUM(Sheet2:Sheet10!B2)
You send me a thank you.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.