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?

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...

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

Thanks You Clever Chap :)