If hire date (column D) is greater than revision date (column F) then delete row

Hi
I am just getting into VBA and macros. The spread sheet i am working on is full of macros, which I cannot believe how much time it actually saves.

This workbook I am working on is a one time use so doing things doesn't have to be as clean as a sustaining worksheet.

All that I am trying to do is check to see if column D greater than column F and if so delete the row.

What would be awesome if the row is moved to a different sheet.

I appreciate the knowledge sharing and your time.

Scott

the actual file has 1368 rows of data, not sure if that matters.

thank you

In your actual workbook is column D and F formatted as a date or is it formatted as general (as in your example workbook). It makes a difference.

I can format both columns as either. the real sheet is formatted as date. If general is easier I can format as such.
thank you
Scott

Here is a way around it, assuming your hand typed in month is 3 characters long and your day/year is 2 and 4 characters respectively. Note the possible need to change the sheet name in code:

Please Login or Register  to view this content.