• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Consolidation

S

Satyaprakash

New Member
Hi People,

I need a small help...
I have numerous excel files in a folder. And numerous such folders. The number of excel files in each folder is dynamic. Each excel workbook has three worksheets. In each folder, I need to have an excel sheet that consolidates the data in each of the other workbooks. Is there any way of doing this via VBA?

Amateur/Beginner
__________________________________________________________________
Mod edit : post moved to appropriate forum …​
 
are you wanting to basically consolidate all the sheet 1s together, all the sheet 2's together etc? so that you start with 3 sheets and end up with 3 sheets? or are you wanting to end up with 1 sheet?
 
@jbaich.... Yeah... For example all of my workbooks have 5 sheets. I want to consolidate 3 - APAC, EMEA and AMERICA. The data in each workbook from these three sheets into a consolidated notebook with the same sheets. Basically there are about a 100 guys who work on parts of data fro the three regions. I collate the data for reporting purpose!
@Luke... I will check them out for sure and let you know. Thanks a lot!
 
You must log in or register to reply here.
Back
Top