VBA: Delete row if not match list

[gd6noob]

Hope everyone is well.

I have a workbook that has 2 sheets.
Sheet1 will have rows delete if Column A is not found on Sheet2 Column A. Sheet2 has around 15-20 criteria's
I tried using Autofilter but it takes some time to complete. My data is anywhere from 60k-100k rows and generally half of that needs to be deleted.

Is there a more efficient way to go about this?

Regards,
gd6noob

 

[Peter_SSs]

100k rows
1st Run: 0.917
2nd Run: 0.921
3rd Run: 1.021

It doesn't really matter, but I was actually referring to the two different codes, since you said "both" worked.
.. and are those units seconds?

 

[gd6noob]

It doesn't really matter, but I was actually referring to the two different codes, since you said "both" worked.
.. and are those units seconds?

It was very close between the 2 codes that worked and yes, those would be in seconds.

 

[Peter_SSs]

OK, thanks for the clarification. Glad they worked for you!