Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

adding cells across multiple workbooks

Posted by Barry Ward on December 07, 2001 3:02 AM

I have a standard worksheet that is layed out in exactly the same format (from template) in about 25 workbooks. I'd like to basically add the corresponding cells in each book together in a new book so I have totalled data, is there a quick way to do this?

Re: adding cells across multiple workbooks

Posted by JJ on December 07, 2001 5:17 AM

Use Consolidation...

DATA, CONSOLIDATE on the Menu Bar

1. Open the relevant workbooks

2. in the workbook u want to consolidate to (summarise to), click Data, Consolidate

3. tick the 3 boxes at the bottom

4. click the reference button, and select Window on the menu bar, then select the 1st file, then drag the range u r consolidating, click back on the ref button

5. click add, then repeat the process for the rest of the files...

Thanks You Clever Chap :)

Posted by Barry Ward on December 07, 2001 6:52 AM

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.