Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 7 And Target.Value = "X" Then LR = Sheets("DDT").Cells(Rows.Count, "A").End(xlUp).Row + 1 Sheets("DDT").Cells(LR, 1) = Target.Offset(0, -1) Sheets("DDT").Cells(LR, 2) = Target.Offset(0, 3) Sheets("DDT").Cells(LR, 3) = Target.Offset(0, 1) Sheets("DDT").Cells(LR, 7) = Target.Offset(0, 4) Sheets("DDT").Cells(LR, 8) = Target.Offset(0, 6) End If End Sub
Sub cancella() LR1 = Sheets("Registro").Cells(Rows.Count, "A").End(xlUp).Row LR2 = Sheets("DDT").Cells(Rows.Count, "A").End(xlUp).Row + 1 Sheets("DDT").Range("A25:G" & LR2).ClearContents With Sheets("Registro") For r = 8 To LR1 If UCase(.Cells(r, "G")) = "X" Then LR2 = Sheets("DDT").Cells(Rows.Count, "A").End(xlUp).Row + 1 Sheets("DDT").Cells(LR2, 1) = .Cells(r, "G").Offset(0, -1) Sheets("DDT").Cells(LR2, 2) = .Cells(r, "G").Offset(0, 3) Sheets("DDT").Cells(LR2, 3) = .Cells(r, "G").Offset(0, 1) Sheets("DDT").Cells(LR2, 7) = .Cells(r, "G").Offset(0, 4) Sheets("DDT").Cells(LR2, 8) = .Cells(r, "G").Offset(0, 6) End If Next End With End Sub
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 7 And Target.Value = "X" Then LR = Sheets("DDT").Cells(53, "A").End(xlUp).Row + 1 ' <<<<<< Sheets("DDT").Cells(LR, 1) = Target.Offset(0, -1) Sheets("DDT").Cells(LR, 2) = Target.Offset(0, 3) Sheets("DDT").Cells(LR, 3) = Target.Offset(0, 1) Sheets("DDT").Cells(LR, 7) = Target.Offset(0, 4) Sheets("DDT").Cells(LR, 8) = Target.Offset(0, 6) End If End Sub