I have two worksheets A, and B. On B I have columns A:J. I would like to copy and paste the rows from worksheet B where column J has a result greater than 0 to worksheet A. Please let me know if that makes sense.
Some videos you may like
Whats the difference between CONCAT and CONCATENATE?
Dim LR As Long, i As Long
LR = .Range("J" & Rows.Count).End(xlUp).Row
For i = 1 To LR
With .Range("J" & i)
If .Value > 0 Then .Offset(, -9).Resize(, 10).copy Destination:=Sheets("A").Range("A" & Rows.Count).End(xlUp).Offset(1)