• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • 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


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

Macro File


Thanks for the inputs

Would it be possible to make it a little bit more flexible,

For example, I will paste all the worksheets into folders that are the same headers , by selecting the file path & selecting the run macro file it should get consolidated into single file

Shall I get that kind of macro file?
Maybe you may find that in threads of an Excel forum …​
But with the link you can group source workbooks by headers in specific folders then launch the consolidation folder by folder …​
As I don't have any, the better is you search on Web threads on the same subject …​