How to write a code within a loop to copy and paste rows on to another Sheet

Hello,

I was hoping someone could help.

I have this loop set up and I want to copy and paste a row if my condition is met on to another sheet.

I've don't need the whole row to be selected, just a certain range--(Like columns A-J)

I've attached the spreadsheet.

here is the code as well

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

This question really should be a FAQ. I see it time and time again and looping just isn't the best way of doing this sort of thing.

Whenever you find yourself creating a loop step back a bit and consider if there isn't a more efficient way. Loops should only be used as a last resort since they can be very slow particularly when many rows are involved.

The fastest and most efficient way I know of doing this is to use an Advanced Filter with the relevant criteria, copying the rows that meet the condition to your other sheet.

Ok, I'll try and search YouTube for some advance filter tutorials to see if I can figure out the code.

It's just that I am more comfortable with looping because I can set multiple conditions within the loop.

Originally Posted by AlphaFrog

I do agree with Richard's comments. But if you only have a few rows of data (say < 1000) then the slower speed of looping isn't necessarily noticeable.

Please Login or Register  to view this content.

THANK YOU SO MUCH FOR THE CODE! I will mark this solved!