Please I need to know two things:
1) you need only to insert the string 'missing part' for each row with the same serial of the previous or you also need to repeat the previous part number?
2) Rows with same serial are contiguous or not?
Thanks a lot
If you need only put string 'missing part' and rows with same serial are contiguous you can use this code.
Sub Macro1()
lastRow = Range("a65536").End(xlUp).Row
For r = 2 To lastRow
If Cells(r, 1) = Cells(r - 1, 1) Then
Cells(r, 2) = "missing part"
End If
Next
End Sub
Regards,
Antonio
Bookmarks