Require Macro to Open Workbook from a folder and copy contents

[ragav_in]

Hi All,

I have a scenario where I need to consolidate data from multiple workbooks/worksheets onto a single worksheet in a different workbook for reconciliation purposes. The scenario is such that the consolidated data will be of the same format as the individual work books. We need to provide the path of individual files to a cell in the Consolidated Workbook and the macro should open all the files in the folder and copy the rows of data and paste it one after another in the consolidated workbook. Once all the data from all individual files is copied a message that copying is complete has to be displayed.

Can anyone help me with the macro to accomplish the situation in hand. Consolidating manually will take long time (hundreds of individual files are present) and hence I would want a macro to finish this task without any error.

Sequence:
1. Put all the individual files in a folder (D:\For Consolidation\Macro\Sep11)
2. Open the file with the Macro and provide this path onto a cell say C4
3. The macro should open the first file in the folder copy all the contents from a sheet name "Information" and copy onto the file starting cell A5 and upon closing should close the individual file
4. Next it has to go to the next file and open it and start appending the data (if the previous book had 45 rows of data and it was filled from A5 to A50; then this has to be appended from A51) and so on.

I thank you all in advance for the effort that you will put in to help me out and I would be grateful to you for providing me the solution.

thanks and regards,
Subramanian V

 

[tweedle]

http://www.mrexcel.com/forum/showthread.php?t=377579

or google consolidating workbooks VBA // consolidating workbooks macro