Loop multiple files based on specific value

[davidmhcampbell]

Hi again all,

I have a bunch of folders containing the same information under a master folder.

These files are .csv's and the name of each file is the same across folders.

e.g. Folder 1:
File 1.csv
File 2.csv
... File X.csv

Folder 2:
File 1.csv
File 2.csv
... File X.csv

Folder .... X:
File 1.csv
File 2.csv
... File X.csv

Each file represents the same type of data and has the same column order and number (file 1 in folder 1 is the same as File 1 in folder 2).

I want 1 to X worksheets in a new workbook containing consolidated information (e.g. all file 1 data from all folders in sheet 1; all file 2 data from all folders in sheet 2... etc)

I have a list of the file names (15) to populate the names of the worksheets and hence the name of the file to pull from. let''s say that that is in A1:A & lastrow

Clear as mud?? Ideas on how to proceed?

Thanks

David

[xladept]

Hi David,

You need to "run" each directory - you need a list of each folder name.