Sub Copy_V2()
Dim wsdest As Worksheet
Dim lRow As Long, i As Long, Réf As Variant
Dim rng As Range, xDate As Range
Dim WS As String, j As Range
Set wsdata = Worksheets("ÇÏÎÇá ÇáÈíÇäÇÊ"): Set r = wsdata.Range("H2")
On Error Resume Next
lRow = wsdata.Columns("G").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
If WorksheetFunction.CountA(wsdata.Range("H4:H" & lRow)) = 0 Then MsgBox "íÑÌì ÇáÊÇßÏ ãä ãáÆ ÚãæÏ ÚÏÏ ÇáÛíÇÈ", vbExclamation: Exit Sub
If WorksheetFunction.CountA(wsdata.Range("G4:G" & lRow)) = 0 Then MsgBox "íÑÌì ÇáÊÇßÏ ãä ãáÆ ÚãæÏ äæÚ ÇáÛíÇÈ", vbExclamation: Exit Sub
For i = 4 To lRow
If wsdata.Cells(i, "G") <> "" Then
WS = wsdata.Cells(i, "G"): Set j = wsdata.Range("G4:H" & lRow)
Set Wdest = Worksheets(WS)
Réf = wsdata.Cells(i, "A").Value
Set rng = Wdest.Columns("A").Find(what:=Réf, LookIn:=xlValues, LookAt:=xlWhole)
If Not rng Is Nothing And Wdest.Cells(i, "A").Value <> Empty Then
For Each xDate In Wdest.Range("H3", Wdest.Cells(3, Wdest.Cells(3, Columns.Count).End(xlToLeft).Column))
If xDate = r Then Wdest.Cells(rng.Row, xDate.Column) = wsdata.Cells(i, "H")
Next
End If
End If
Next i
j.ClearContents
On Error GoTo 0
End Sub
tفي هذا السطر Set wsdata = Worksheets("ÇÏÎÇá ÇáÈíÇäÇÊ")
هذا هو
Doc111.docx