Hi all,

I have a spreadsheet that has 2 worksheets. 1 is called "active" , the
other "inactive". The sheet has 5 columns, one of which is called "Qty on
hand". When "Qty on hand falls to zero, the entire row needs to be cut and
pasted into the "inactive sheet". This needs to be automated.

What needs to happen is I need to create a macro that will clean up the
active sheet. It needs to be able to check the whole "active" sheet and cut
and paste all the rows where "Qty on hand" is zero to the "inactive" sheet.

I know you all will have suggestions.

Thanks