If (ActiveCell.Offset(0, 3).Value <> "X") Then
If (Range("A1").Offset(SADOffsetCount, 3).Value <> "X") Then
Range("A1").Offset(SADOffsetCount, 0).Select
Range(ActiveCell, ActiveCell.Offset(0, 2)).Select
Selection.Copy
ActiveCell.Offset(0, 3).Value = "X"
Worksheets("Duplicate_Scan").Activate
Range("A1").Offset(SADInputCount, 0).Select
Selection.Offset(0, 3).Value = SADOffsetCount + 1
ActiveSheet.Paste
SADInputCount = SADInputCount + 1
Worksheets("People_Data").Activate
Range("A2").Offset(SADLineCheck, 0).Select
End If
Range(ActiveCell, ActiveCell.Offset(0, 2)).Select
Selection.Copy
ActiveCell.Offset(0, 3).Value = "X"
Worksheets("Duplicate_Scan").Activate
Range("A1").Offset(SADInputCount, 0).Select
Selection.Offset(0, 3).Value = SADLineCheck + 2
ActiveSheet.Paste
SADInputCount = SADInputCount + 1
Worksheets("People_Data").Activate
End If
Bookmarks