کد:
Sub nash()Dim a
a = Range("a1")
Application.ScreenUpdating = False
With Range("e3:e" & Cells(Rows.Count, "e").End(xlUp).Row)
If Range("e3") = Sheet1.Range("M1") Then
.AutoFilter 5, Sheet1.Range("M1")
.Offset(0).EntireRow.Copy
Sheets("sheet2").Select
Range("A2").Select
Selection.Insert Shift:=xlDown
ActiveSheet.Paste
Rows("2:2").Select
Selection.Insert Shift:=xlDown
Range("a2") = a
.AutoFilter 5
ActiveSheet.Cells.EntireRow.Hidden = False
Range("a2").Select
End If
End With
Sheet2.Select
Application.ScreenUpdating = True
End Sub
با تغییر دادن اینها حل شد
علاقه مندی ها (Bookmarks)