بعد اذن أخى سليم
تفضل اخى
كله بالاكود لانه مينفعش تعديل ع وجود معادلات الاستدعاء
هذا كود الاستدعاء فى حدث الورقه
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cl As Range
Dim LR As Integer
Dim sh2 As Worksheet
Set sh2 = Sheet2
If Target.Address = [c2].Address Then
LR = sh2.Cells(Rows.Count, 1).End(xlUp).Row
For Each cl In sh2.Range("A4:A" & LR)
If [c2] = cl Then
[c4] = cl.Offset(0, 1)
[b6] = cl.Offset(0, 2)
[b8] = cl.Offset(0, 3)
[b10] = cl.Offset(0, 4)
End If
Next
End If
End Sub
وهذا كود الترحيل
Sub ragab()
Dim cl As Range
Dim LR As Integer
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Set sh1 = Sheet1
Set sh2 = Sheet2
LR = sh2.Cells(Rows.Count, 1).End(xlUp).Row
For Each cl In sh2.Range("A4:A" & LR)
If sh1.[c2] = cl Then
cl.Offset(0, 1) = sh1.[c4]
cl.Offset(0, 2) = sh1.[b6]
cl.Offset(0, 3) = sh1.[b8]
cl.Offset(0, 4) = sh1.[b10]
End If
Next
End Sub
وهذا الملف
اوفيسنا.rar