Copy entire row if Column M value >0 to dedicated Workbook (Backorders)

[angel1982]

Can someone please help me.

I don't know VB and have tried other codes provided in the forum but doesn't seem to work.

I have a spreadsheet with orders - column M displays the amount of units still outstanding.

I need a macro that will look at the values in column M and if the values are > 0 then it must copy entire row to a dedicated workbook (backorders).

Can this be done?

Any help will be greatly appreciated.

Thanks