View Single Post
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

use a heading <ddate
today 25 feb 2005 i.e. 2/25/03
criteria

ddate
<2/25/2003

use advance filter and copy to some ohter location.
see help advance filter.

create a macro on this

==================
Greg B... wrote in message
...
Hi all

I am wondering if there is a code that i can run automatically, I have to
have my database no older than 2 years. What i would like is for a macro

or
something to search the entire a column find the dates older than 2 year

and
move then to another sheet.

Thanks in advance

Greg