All articles with 'consolidate' Tag

Consolidate data from different excel files (VBA)

Published on Apr 9, 2012 in Automation, Excel Howtos, VBA Macros
Consolidate data from different excel files (VBA)

Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.

Continue »