وعليكم السلام ورحمة الله تعالى وبركاته
تفضل جرب اظنه اسرع
Sub TEST1()
Dim WS As Worksheet, sh As Worksheet
Set WS = Sheets("Feuil5"): Set sh = Sheets("Feuil6")
LR = WS.Cells(Rows.Count, 3).End(xlUp).Row
Application.ScreenUpdating = False
sh.Range("A10:M" & sh.Rows.Count).ClearContents
a = WS.Range("A10:K" & LR).Value
Dim tmp(): ReDim tmp(1 To UBound(a))
For I = LBound(a) To UBound(a)
On Error Resume Next
If a(I, 2) = sh.[E3] And a(I, 11) = sh.[F3] Then n = n + 1: tmp(n) = I
' بما ان رموز الفواتير ثابثة بين 0 . و 1 اجعل الشرط بهده الطريقة
' If a(I, 2) = sh.[E3] And a(I, 11) >0 Then n = n + 1: tmp(n) = I
Next
ReDim Preserve tmp(1 To n)
a = Application.Index(a, Application.Transpose(tmp), _
Application.Transpose(Evaluate("Row(1:" & UBound(a, 2) & ")")))
sh.[A10].Resize(UBound(a), UBound(a, 2)) = a
Application.ErrorCheckingOptions.BackgroundChecking = False
Application.ScreenUpdating = True
End sub
حساب العملاء 2024.xlsm