If there is a formula or function to this outside of VBA or macro, I would rather go that way but I don't think there is. Even the VBA seems to be a doozy. I found similar questions but I cannot adapt the codes to my workbook for them to work properly, or at all.

In my Worksheet 1, currently named "Master" I have thousands of entries. When serial number in column A matches a serial number in another worksheet called "Reports", the date associated to the matched serial number in the "Report" worksheet is displayed in column P of the Master worksheet.

I now need to have all the rows that does not contain a date in column P of the Master worksheet to be copied in a separate worksheet. There is a received date column in the Master worksheet and the condition to copy the rows without a date in P needs to also include the rows with a date in P that is less recent than the date in D.

In other words, I need a worksheet to display all the rows from the Master worksheet except the rows with a date in P or a date in P that is later than the date in D.

It is not a one time procedure so I need the new Worksheet to be updated as the Master receives new entries or dates in column P are being populated.

Thanks again for the great help!