Hello experts, I have in a folder csv files (files attached).
All of the files have the same number of columns and same header.
I would like to run a macro through a xlsm file and do the following
1-Enter in column A the csv file names of each file imported
2-Import one time the header and bellow all the data of each csv file into one single file as of column B as column A is reserved for the csv file name
Please see attached the result.xlsm and the reference csv files.
In my example I put just 2 files but the idea is that the macro loops the various files located in the reported folder.
Thank you very much for your help.