Hi /r/excel,

I have been given some large data sets coming in at around 150 MB per book (large table, roughly 550,000 entries). Now this is unfeasible on most computers though my gaming PC can manage after taking a little while to open it.

To keep it simple, I want to extract rows based on values in a specific column within the data set and then output them into a new sheet. Boiled down I am trying to replicate a filter... The reason why I want to try automate it is that I have several of these and my filter parameters might change down the line so don't want to do this over and over again! Ideally I have my filter criteria listed in a text or excel file and then get the vba to read from there.

I have initially opted to try do it through VBA, essentially extracting rows to a new sheet and then copying this output sheet to a new small workbook after. Before I get too deep into it I wanted to run it past the folks here and see how you would go about it. Do I have any other options which might be more simple?

Many thanks for any tips or advice.