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

 

[Guest]

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