I have written this code to copy a row if the condition is met. However, It was decided that not all the data from the Row is needed, how would I only copy Columns A:L for each row that meets the condition and put it into the second worksheet as shown.
Code
Worksheets("Raw Data").Activate
a = Worksheets("Raw Data").Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To a
If Worksheets("Raw Data").Cells(i, 6).Value <= 10 Then
Worksheets("Raw Data").Rows(i).Copy
Worksheets("Hot List").Activate
b = Worksheets("Hot List").Cells(Rows.Count, 1).End(xlUp).Row
Worksheets("Hot List").Cells(b + 1, 1).Select
ActiveSheet.Paste
End If
Display More