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
|