Not sure since there's not much detail provided in the post ..
Perhaps this sample from my archives might provide some ideas:
http://savefile.com/files/2243119
Auto-Extract Lines by date into a new sheet.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brian" wrote:
Howdy All,

I want to copy info from a row on 1 sheet (sheet name = RAW) to another IF a
date in 1 of 4 columns (RAW Columns G thru J) is the latest date (MAX).


I want to copy the whole row, if the date in that range is the latest.

Any ideas?

Thanks,
Brian