VBA: How to copy source workbook name to fill first column

  • I need assistance of experts in the house on how to copy source workbook names along with other data in files I am to merge in new worksheet. The code will create a new column in the new worksheet and will fill it with the source book name (preferably first column)

    I have this code that merge files based on number of rows already but with no demarcation on where one ends and another begins:


    I have sample files for testrun too.

    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!