VBA for Copy + Paste Data

craig.r18

New Member
Joined
Jul 23, 2010
Messages
1
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!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,020
Members
409,675
Latest member
audeser

This Week's Hot Topics

Top