Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$2" Then Application.ScreenUpdating = False Range("A2:E65536").ClearContents For Each Rng In Sheet1.Range("A:A").SpecialCells(xlCellTypeConstants) If Rng.Value = Target.Value Then Rng.Resize(1, 4).Copy Sheet2.[a65536].End(3).Offset(1).PasteSpecial (xlPasteValues) End If Next Application.ScreenUpdating = True End If End Sub |