Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data based on a count... | Excel Worksheet Functions | |||
I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
How do I copy info from paper port to a cd? | New Users to Excel | |||
reminder notifications in a column | Excel Discussion (Misc queries) |