Select and then cut and paste rows based on a value in 1 cell of t

[mendozalaura]

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

 

[Don Guillett]

Suggest a macro that uses
data>filter>autofilter>filter on the column>copy the result to the other
sheet.