وعليكم السلام ورحمة الله تعالى وبركاته
Sub test()
Dim wb As Workbook, WS As Worksheet, dest As Worksheet
Set wb = ThisWorkbook: Set WS = wb.Sheets("Sheet1"): Set dest = wb.Sheets("Sheet2")
Dim j&, col&, ligne&, r As String
Dim Rng As Range: col = 12: r = dest.[B19]
ligne = WS.Cells(Rows.Count, col).End(xlUp).Row
With Application
.ScreenUpdating = False
dest.Range("C22", Range("AD" & Rows.Count).End(4)).ClearContents
For j = 22 To ligne
If UCase(WS.Cells(j, col)) = r Then
Set Rng = WS.Range(WS.Cells(j, 3), WS.Cells(j, 30))
dest.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Resize(1, 28).Value = Rng.Value
End If
Next j
If Application.WorksheetFunction.CountA(dest.Range("C22:AD22")) = 0 Then
MsgBox "غير موجود" & " / " & r, vbOKOnly + vbCritical + vbDefaultButton1 + vbApplicationModal, "انتباه"
End If
.ScreenUpdating = True
End With
End Sub
تجربة 2.rar