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.