Sub CombineAllSheets()
Dim ms As Worksheet, LR As Long, i As Long
Application.ScreenUpdating = 0
Application.DisplayAlerts = 0
On Error Resume Next
Set ms = Sheets("Output")
With Sheets("Data")
LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
For i = 2 To LR
If ms.Range("E1") = .Range("C" & i) Then
.Rows(i).Copy ms.Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i
End With
Application.CutCopyMode = 0
Application.ScreenUpdating = 1
Application.DisplayAlerts = 1
Set ms = Nothing
End Sub
Bookmarks