Dear all,
I would like to post following request:
On my network there is a folder called "a" with a changing number of subfolders. In each of these folders there is a changing number of excel files, all of them with different unknown names. There is also something the files have in common: they all have - beside Sheet1, Sheet2 and Sheet3 - a sheet callled "Name" with data starting at line 5 and in columns A till X. The number of filled lines is random per file.
My question:
I would like to make a consolidated excel file in which I can load all the different sheets callled "Name" of the different files. This consolidated excel file has the same format as all the other excel files, meaning it also has a sheet called "Name" (or we can call it "ConsolidatedName" to make it easier) and it captures the data starting line 5 and in columns A till X.
I would like to add two more details on the right side; in column Y the name of the file where the data line comes from should appear and in column Z the name of the folder where the line (and the excel file of column Y) should appear.
I allready started but it's not in an end state yet:
Who can help me out??
Bookmarks