Copy info IF MAX

[Brian]

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

[Max]

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
>
>
>