Custom filtering for multiple criteria

[angeb]

I have a huge list from which i need to extract data.
Ie from a column listing surnames of adams, anderson, doyle, alexander, aarons, berry, cummins, crimmins, I need to extract all the cummins, adams, berry and doyle, with their associated information from corresponding columns to a seperate worksheet/workbook.
Yes I could use the basic column filter, but just one of the spreadsheets I need to do this with has over 2mill names in it.
If anyone has ideas I would appreciate it, even more so if the lingo could be... dumbed down so to speak as I am a relative newbie.

Thanks

 

[namliam]

one of the spreadsheets I need to do this with has over 2mill names in it.

Excel doesnt go over 1 mill lines?

 

[angeb]

Each worksheet holds a max of 1,048,576 lines, but my workbooks have multiple worksheets, hence the over 2mill lines. I have almost 6mill lines in another workbook.
It's extremely cumbersome and slow when I try to work with a file that size, which is why I wish to have my source workbook, then a seperate one that has minimal data that I work with. Hence the custom filter.

 

[namliam]

You could expand on this code:

    Sheets("Sheet1").activite
    ActiveSheet.Range("$A:$L").AutoFilter Field:=3, Criteria1:="Smith"
    ActiveCell.CurrentRegion.Select

 

[Rx_]

http://www.cpearson.com/excel/importbigfiles.aspx
Older website (2007) that has a free download with Excel code to download really large data sets and put them into different pages.

There is a case here for importing all of your data into a Microsoft Access MDB table. Then use Microsoft Excel External Data - Excel Query to sort and filter the data and return the subset to the Excel Worksheet.

It isn't difficult to do. You have a perfect Forum here to learn one step at a time and be successful. Microsoft Query also lets Excel link to an Access Query (or view).
This could allow a simple query interface in MS Access - then open Excel to import the result. A little bit of automation could potentially save time over the long run.

 

[angeb]

Ok so this is the name of the file Births4.xlsx, the column I want it to filter is Surname (4th column) and this is the cell range A274579.

I want the resulting filtered data to end up in FamilyTree.xlsx. Sorry to be a pain but I really am totally new to VBA And thanks for your help so far, much appreciated