Consolidate Function

[VTbank]

11 years ago, I consolidated over 50 workbooks with a "Consolidate" function in Excel. This worked great in that I was able to do what used to take 5 hours and complete in about 5 minutes. I can no longer find this function. Do I have to learn VBA code to consolidate now?

 

[Andrew Poulsom]

Do you mean Data|Consolidate?

 

[VTbank]

Yes, consolidate data from 50 or so cost centers into a Total Division report.

 

[VTbank]

Andrew, I may have misunderstood your reply. Data|Consolidate is for only within a workbook. I need to consolidate 50 workbooks.

 

[Atholl]

Try a search of this board; there is some VB code for multiple workbook consolidation.

Atholl

 

[Atholl]

Try this:

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=consolidate