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

M

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top