Macro to select data within a date range.

Hi All,

I'm rather struggling with something and would really appreciate some help.

I have a spreadsheet with up to 1000 rows. The data we are interested in is "leave date" and "confirmed".

I need a macro or code to copy the whole row when the "leave date" was within 13 weeks and confirmed = no. If possible, the new data would appear on a new worksheet in the same book.

Please see attached data sample.


(Ideally, I would be using a database application however I don't currently have the resource)