Macro To Compare Two Dates

example.xlsHi all,

I'm new here but have heard this is a great place to get Excel help.

Just a quick question - What sort of Macro would I need to create to be able to compare two dates that are always in the same columns and show only rows that have a "Closed Date" that was after a "Due Date".

Here's what I'm working with:
1st.png

Here's what I'm hoping to achieve, preferably in Macro form because I have many spreadsheets come out everyday that would need this comparison:
2nd.png

Many thanks!
Dylan

Please see attached example.

Picture:

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

These are still pictures that are uneditable.

I have no data that I can upload, the ones in these screenshots were just 7 lines I threw together. The actual data I use I can't upload.