Analaysis file and multiple csv files

[matt3m]

Hi,

I have many .csv files that have identical format (columns A to L, row 1 to 30), no header.

I have an analysis file where, having already copied and pasted the data in one csv file, the data from A:2 to L31 is idential to one of the .csv files, since I just copied and pasted. I added a header line, so this is row 1, A:L. The next few columns (L to P) and rows (1:31) are the analysis columns, based on the data from A:2 to L31. L1:P1 is a header line. I have a "summary section" based on all the data which I arbitrarily put in cells R2,S2,T2 with corresponding head liner R1,S1,T1.

The bottom line is that I want to be able to easily put data from any of the .csv files into the analysis file .xls
Since I go back and forth between different .csv file, it would be awesome to have some kind of dropdown menu of the file names .csv, so i can quickly read the data into my analysis file.

How can I do this?

Thanks,
Matt

[mrice]

The following macro code will pull out the names of all the CSV files in a folder and use them to populate a dropdown list (in A1) in this example.

Please Login or Register  to view this content.

This could be adapted to drive a change event driven macro to read in the selected csv file into the appropriate area of the sheet.

[matt3m]

Hi OK,

This seems like a good start...would you mind commenting the lines. I am new to the macro world (but have programmed in c++ and python)

[mrice]

The first section creates a comma delimited string of all the file names in the folder with the *.csv format by looping until no new names are found.

The second section uses this string to apply validation to the specified range of cells - in this case just one.

[matt3m]

OK Thanks,

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.