Hello and thank you for the replay.
For the first question - i need more rows because each time i copy to the table different number of rows and after addition i deleting an empty rows.
The code that i use:
Private Sub Worksheet_Change(ByVal Target As Range) r = Target.Row
c = Target.Column
If c <> 1 Then Exit Sub
Application.EnableEvents = False
NextLineValue = Cells(r + 2, c)
If NextLineValue = "The signature indicates that all characteristics are accounted for; meet drawing requirements or are properly documented for disposition." Then
Rows(r + 1).Insert
End If
Application.EnableEvents = True
End Sub
i prefer that this will be done automatically without "Enter"