Macro to Filter and Delete Based on Date

[Andrew.Trevayne]

Hi,
Sorry but need help once more, I'm putting together a script that I will be using for my Auditing activity.
I have an Excel Sheet That contains some data and on column "F" are dates. I would like to be able to run a Macro to get only Dates that is 60 days old or older.

Example:
Today is 11-September-2012
From my Attached List I need a Macro that will only capture dates July 11, 2012 or Older (June, May, April or even from last year).
The rest that are still within the 60 Days period will be deleted.



Is this possible? Thanks once again, this will be very helpful If I managed to pull this out.

[watersev]

hi Andrew.Trevayne, please check attahcment, run code "test"

[Andrew.Trevayne]

Hello Watersev, Thank you! Tried it and it's working.
However some rows are not being deleted. From my Dummy xls it stops on row 313.

Do I need to change something with the code?

Please Login or Register  to view this content.

[Andrew.Trevayne]

Sorry my bad, those rows do not have DATES!
This is just perfect! Thank you again.

[watersev]

some rows from your sample file have no data in F column, do you need to delete them as well?

[watersev]

you are welcome, disregard my last post

[Andrew.Trevayne]

That's not necessary, this is just perfect! Thank you so much sir! This will help me a lot.