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

VBA to Merge Files

S

ShoaibAli

New Member
I have 10 files and each files contains Sheet1 how can i put these 10 files into one file as 10 sheets.


Please share VBA Code
 
Employ Power Query/Get and Transform. This built in excel functionality is designed to do this. Look at the link in my signature.
 
You must log in or register to reply here.
Back
Top