Macro pick up range that meets criteria

[NevPS]

Can someone help me create a macro to pick a range of cells that meet a criteria from another cell and paste into another worksheet.
For example,I have data in A4:K300. If any row in column K = 0, I want to pick the rows that met that criteria but only pick up the data from columna A:J post to another sheet.

 

[vcoolio]

Hello NevPS,

You could try the following code:-

Sub Test()

Application.ScreenUpdating = False
        
        With Sheet1.Range("K3", Sheet1.Range("K" & Sheet1.Rows.Count).End(xlUp))
                .AutoFilter 1, 0
                .Offset(1, -10).Resize(, 10).Copy Sheet2.Range("A" & Rows.Count).End(3)(2)
                .AutoFilter
        End With

Application.ScreenUpdating = True

End Sub

I'm assuming that your headings are in row3.
I've used sheet codes (Sheet1 and Sheet2) to reference your worksheets. This may need to be altered.

I hope that this helps.

Cheerio,
vcoolio.