Option Explicit
Sub CommandButton1_Click()
Range("A2:E100").Clear
Dim i As Integer, Myrow As Long
Dim ws1 As Worksheet: Set ws1 = ThisWorkbook.Sheets("Data")
Dim ws2 As Worksheet: Set ws2 = ThisWorkbook.Sheets("Översikt")
Myrow = 4 'change this to suite you
For i = 3 To ws1.Range("A65536").End(xlUp).Row
If ws1.Cells(i, 3) > 0 Or ws1.Cells(i, 5) > 0 Then ws1.Rows(i).Copy ws2.Cells(Myrow, 2)
Myrow = Myrow + 1
Next i
Blad1.Range("E2:E100").Font.Italic = True
Blad1.Range("A1:AF100").Interior.ColorIndex = 2
End Sub
Bookmarks