Import Multiple CSV files and consalidate in master sheet

[Hesham911]

Hi,

I am looking for a code to import multiple csv files into a master workbook. But before importing them, it will need to apply filters on some of the fields and then copy over matched data. Each csv file have their own criteria to be applied to and then copied over.

Can you please advise on a code to import these files in below order:
-Selecting target csv files with their names, so it would say "Please select ...(File name)..."
-When target file is selected, apply filter 1 to csv 1 and filter 2 to csv 2 and so on
-Copy only matched data from filter (for ex csv 1 need a criteria in field 2, csv 4 need a criteria in field 6)
-close all imported csv file except master workbook.

One last thing please, how to apply multiple criteria for a single field?

Hopefully my request make sense, and please let me know if you require any more info.

Many thanks in advanced

 

[AVK]

plz check below link will helpful for you.
https://www.extendoffice.com/documents/excel/3230-excel-import-multiple-csv-files.html

 

[Hesham911]

Thanks AVK.

I am afraid that the code only copies all files into the workbook without any other actions. Need to apply criteria/filters on CSV files before coping result into workbook.

Regards

 

[Joeyjoejoejrshabidu]

This definitely sounds like Power Query would be the best solution as you want to filtering and transformation etc. Power Query doesn't do multiple files out of the box, but you can get it to work. See this post for details How To Import All Files In A Folder With Power Query.

 

[Hesham911]

This definitely sounds like Power Query would be the best solution as you want to filtering and transformation etc. Power Query doesn't do multiple files out of the box, but you can get it to work. See this post for details How To Import All Files In A Folder With Power Query.

Thanks for sharing, it's a very interesting way of importing files.