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)
Bookmarks