Excel Command for analyzing dates and transferring data

**kocg047** · 06-13-2013, 04:41 PM

Im looking for a command to analyze a date in columns 1 and 2, and if the date in column 1 is greater than the date in column two, copy the row a specific set of cells in that row and paste into another sheet. Is this possible, and where do I paste the command?

**humdingaling** · 06-13-2013, 09:33 PM

yes possible

please attach a sample workbook. Make sure the data make clear what is needed. Include BEFORE and AFTER sheets in the workbook if needed to show the results you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**kocg047** · 06-14-2013, 04:11 PM

(See file attached)

Im looking for a function which will analyze the dates in columns "P" and "Q" (rows 9-1314), and if the date in column "P" is greater than the date in column "Q", copy the information in columns C, D, E, F, G, and H (in that respective row) and paste it into sheet 2.

**humdingaling** · 06-15-2013, 12:30 AM

If you change the name of sheet2 you will need to change it in the macro as well

Sub CopyRow()
'
Dim cRow, lRow As Integer

    cRow = 9
    lRow = Sheets("Sheet2").Range("A65536").End(xlUp).Row + 1

    For cRow = 9 To 1314
    
        If Range("P" & cRow).Value > Range("Q" & cRow).Value Then
            Worksheets("Owner Review").Range("C" & cRow, "H" & cRow).Copy _
                Destination:=Worksheets("sheet2").Cells(lRow, 1)
            lRow = lRow + 1
        End If
        
    Next

End Sub