My sheets has a list of products that need to copy to a 2nd sheet IF there is a quantity > 0 in the Col C cell for the product. I HAVE GOTTEN THIS TO WORK.
HOWEVER when the macro below selects, copies, & pasts that row it does so for the entire row on to infinity. I would like to copy only range A:E if column C has a quantity > 0.
I have a macro that copies and moves but would like to alter it so that it isnt pasting to the entire row on the 2nd (target) sheet.
Thanks!!
Please Login or Register to view this content.
Bookmarks