How to copy nonconsecutive cells into another sheet consecutively

Hello,

B+N Total sheet is where the data is and the decider is Column 'AF' which is already formulated and has 2 options: 'MMS' or 'Retail'.

I'm trying to write a code which needs to do:

If B+N Total sheet's AF Column has 'MMS' then copy that row and paste it into ADI MMS consecutively.

Just like the example attached Row 2,3,5 is MMS and not row 4. So I'm trying to get those rows in periodical order as Row 2,3,4 into ADI MMS Sheet.

Thank you in advance!

Something like this can do it. Feel free to name your sub and the variable whatever you want.

Please Login or Register  to view this content.

This looks at a range in AF2:AF50, checks if it's something, and if it is copies the entire row to another sheet 1 row below the last thing in column A.

Awesome, glad I could help out.

I only started coding a few weeks ago but so far I'm pretty decent at For Each and Do While loops.

Automation can be so efficient.