Private Sub Worksheet_Change(ByVal Target As Range) Dim i% If Target.Address = "$A$1" Then i = [a2:a65536].Find(what:=Target, lookat:=xlWhole).Row Range(Cells(i, 2), Cells(i, 11)).Value = [b1:k1].Value End If End Sub
Private Sub Worksheet_Change(ByVal Target As Range) Dim i% If Target.Address = "$A$1" Then i = [a2:a65536].Find(what:=Target, lookat:=xlWhole).Row Range(Cells(i, 2), Cells(i, 11)).Value = [b1:k1].Value End If End Sub