السلام عليكم
ضع هذا الكود في حدث الورقة PART 1
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Set MyRng = Sheets("1").[B6:I4090]
If Not Intersect(Target, [H2,H22,H42]) Is Nothing Then
Cells(Target.Row + 5, 5) = Application.VLookup(Target, MyRng, 3, 0)
Cells(Target.Row + 7, 5) = Application.VLookup(Target, MyRng, 4, 0)
Cells(Target.Row + 9, 5) = Application.VLookup(Target, MyRng, 8, 0)
Cells(Target.Row + 11, 5) = Application.VLookup(Target, MyRng, 6, 0)
End If
End Sub