Örnek:

4
●205
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 7 And Target.Value = "+" Then Target.EntireRow.Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End SubG sütununa + yazarsan Sheet 2 'ye otomatik olarak kopyalar.