Look for a quicker code to replace this loop approach

Hello everyone,

My code below is to extract rows in sheet 1 to sheet 2 with the inefficient loop. The condition is to check if the date matches (as shown below).

Is it possible to use something like AutoFilter to improve the efficiency? Thanks.

Please Login or Register  to view this content.

Many thanks, davesexcel.

For the criteria, I need to find the previous month end date first based on the cell value and from there to check:

Please Login or Register  to view this content.

Can AutoFilter handle this?

Thanks again.