VBA for Copy + Paste Data

[craig.r18]

I'm currently working on a document containing 3 worksheets. I'm looking to copy and paste rows of data from worksheet 1 and worksheet 2 into worksheet 3's next empty row.

Basically

Looking at worksheet 1 and worksheet 2

If column B = >0
Select and copy whole row
And paste to worksheet 3's next empty row.

Is this possible at all?

Thanks in advance for any help!

 

[VoG]

Try

Sub Cpy()
Dim LR As Long, i As Long, ws As Worksheet
For Each ws In Worksheets(Array("Sheet1", "Sheet2"))
    With ws
        LR = .Range("B" & Rows.Count).End(xlUp).Row
        For i = 1 To LR
            With .Range("B" & i)
                If .Value > 0 Then .EntireRow.Copy Destination:=Sheets("Sheet3").Range("A" & Rows.Count).End(xlUp).Offset(1)
            End With
        Next i
    End With
Next ws
End Sub