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

Macro required for merging all excel files in a folder

D

dileep

New Member
Having couple of excel files in a folder, want to merge all the files data into a new excel file. In each workbook there are two sheets, sheet1 data of all files should be merged to new file sheet1 tab and all the sheet2 data should be merged to the same new file sheet2
 
Check out the Copy/Paste/Merge section on Ron's site here:

http://www.rondebruin.nl/tips.htm


He has several macros and add-in that are very handy for merging files and creating summaries.
 
Hi Dileep,


Welcome to the forum..


Please check the below post.. hope its help you..

http://chandoo.org/forums/topic/how-to-compile-the-excel-file#post-49475


Regards,

Deb
 
You must log in or register to reply here.
Back
Top