compare matching data in 10 offset rows

[scorpweb]

hey all,

i'm trying to compare data between the active row and the rows below currently have it for -1 row (I have it copied for -2 aswell) ...I need to scan up to 10 rows.

difficulty i'm having is the duplicate line is still used later in a cell comment. so in doing this i would need EVERY duplicate to still be able to picked up in a cell comment.

i don't mind how it can pick up the duplicates as long as i can work with the data

any ideas on how i can proceed with this?

    ElseIf Sheets("Data").Cells(e, cintColAC) = Sheets("Data").Cells(e, cintColAC).Offset(1) And Sheets("Data").Cells(e, cintColLocation) = Sheets("Data").Cells(e, cintColLocation).Offset(1) And Sheets("Data").Cells(e, cintColSchedStart) = Sheets("Data").Cells(e, cintColSchedStart).Offset(1) And Sheets("Data").Cells(e, cintColSchedEnd) = Sheets("Data").Cells(e, cintColSchedEnd).Offset(1) Then
    Sheets("SLOT_line").Cells(Start_row + increment + intLocOffset, Start_col).Select
    Selection.AddComment.Text (comm2)