Copy info IF MAX
 

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

Copy info IF 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