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

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

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

Suggest a macro that uses
datafilterautofilterfilter on the columncopy the result to the other
sheet.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mendozalaura" wrote in message
...
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