vba macro to consolidate selected data from multiple workbooks

Hello All,

I work on multiple excel workbooks. I have 50 workbooks. each consists of around 35 columns. On daily basis I have to filter out data from few columns of each workbook and paste the data one below the other and make one final file. thts everydays tasks.

I want a macro wherein I can give the list of filters that I want apply on select columns. The macro will go to each workbook and apply given filter on given column and copy the data to a fresh workbook one below the other.

If anyone can help me with this,

Thanks.

I have attached 3 source files and one final file for reference.

procedure is as follows. I open source_1 file and apply below given filters on that file.

select below given values on the columns with header given below:
Header H = "S2389"
Header I = greater than 1000 (i.e. ">1000")

copy the data and paste in a new excel workbook.

then I repeat the same steps on source_2 file and paste the data in newly open excel workbook in above step.

and same steps for source_3 file.

in the end I get one final file which consists of filtered data from 3 source files.

I hope I am pretty clear this time. But still let me know in case of any confusion.

Thanks.

Mumps1,

Great. The code works perfectly well, just one catch here.

Its not mandatory that filter will be on 6th or 12th column necessarily. That is why I mentioned header "H" and header "I". Filter will be based on header. So code should give us the freedom to enter header name for putting filter.

Rest code is very smooth and give exact result.

Thanks a ton once again for the help.

Mumps1,

very sorry for the late reply. There was some issue with my system. Hence, could not login. But I checked just now, and its working absolutely fine.

Thanks a ton for your help. very happy.