السلام عليكم
اذا اردتها بالكود
Sub Macro1()
Dim iNm As String
Dim Lr As Long, i As Long
Dim R As Integer
Dim d1 As Double, d2 As Double
''''''''''''''''
iNm = Range("B1").Value
d1 = Range("B2").Value2
d2 = Range("B3").Value2
''''''''''''''''
Range("D6:K35").ClearContents
''''''''''''''''
Application.ScreenUpdating = False
With ورقة1
Lr = .Cells(.Rows.Count, "C").End(xlUp).Row
For i = 6 To Lr
If iNm = CStr(.Cells(i, "C")) Or iNm = CStr(.Cells(i, "D")) Then
Select Case .Cells(i, "F").Value2
Case d1 To d2
R = R + 1
Cells(R + 5, "D").Value = R
Cells(R + 5, "F").Resize(1, 4).Value = .Cells(i, "F").Resize(1, 4).Value
If iNm = CStr(.Cells(i, "C")) Then
Cells(R + 5, "J").Value = .Cells(i, "J").Value
Else
Cells(R + 5, "K").Value = .Cells(i, "K").Value
End If
End Select
End If
Next
End With
Application.ScreenUpdating = True
End Sub
مع الشكر لاخي جمال
ودمتم في حفظ الله
عمل كشف حساب بتاريخ بداية وتاريخ نهاية.rar