Copy same row from multiple workbooks to new workbook.

[angusfire]

Morning: I have a set of workbooks containing rainfall data for all parishes in Louisiana. The workbooks are .csv files and there is one for each parish. I would like to extract a particular range (B21:H21) from each workbook and place them into an existing master workbook. The extracted range would be copied to a seperate row in the master workbook; perferably starting at AB2:AH2 and going down from there with each .csv file imported. Ideally the parish name of the worksheet in the extracted workbook would match the parish name in AA2 of the master workbook and paste the data in AB2:AH2 and so on down the list. Thanks in advance for the help; if there is any.

I have attached a representative workbook .csv file for the data export and a representative master workbook in which to paste it.

The worksheet name "Acadia_mean" of the .csv file would need to match the cell name "Acadia" in the master workbook and paste the data in the corresponding row. I have highlighted the data to be extracted.

Acadia_mean.csvMasterbook.xlsx

Shane

[JBeaucaire]

Can you upload a couple more CSV files, preferably ones with the more complex names - ie. VERNON (Northwest) and similar. Thanks.

Also, there any reason not to just create a new table each time the macro is run listing only the files that were found, then sorted? That's probably less plumbing then trying to insert into the existing table. The newly created table would have the exact same layout, but only list the parishes found in the macro run.

[angusfire]

Think I found something that works. Given that the parishes are listed in alphabetical order then this method gives me what i need.

Please Login or Register  to view this content.

[JBeaucaire]

Except for the matching to existing rows, that should work nicely.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.