Could you please help me with a VBA code that would look at column M in sheet 1 and if any cells in column M =>10,000,000 then this entire row gets copied on another worksheet. Thanks so much for your help.
Application.ScreenUpdating = False
Dim LR As Long, i As Long
LR = Range("M" & Rows.count).End(xlUp).Row
For i = LR To 1 Step -1
If Range("M" & i).Value => "10,000,000" Then Rows(i).Copy Destination:=Sheets("Sheet2").Cells(Rows.count, "A").End(xlUp).Offset(1)
Application.ScreenUpdating = True