Copy Non-Blank rows in a Range and Paste

Thanks so much for sticking with me Carim!

Now it looks like if either column V or Y is blank, the row will not be copied. My hope was that it would only skip the ones that are blank in row Y.

In the sheet below, I deleted the contents of cell V223 and cell Y224 so I could see which column was being referenced.

Test edit29 - ozg.xlsm

Thanks again Carim and sorry I am not adequately describing the symptoms. The row is being excluded if column Y is blank which is great but rows are also being excluded if only column V is blank. I removed the contents of V223. Y223 still has data in it but row 223 is not being copied.

Test edit29 - ozg.xlsm

PERFECT!!! Thanks so much Carim!!

You have done so much that I hate to ask just out of curiosity but the only change I see between the last two versions of code were the column reference in this line:

LstRw = Cells(Rows.Count, "F").End(xlUp).Row + 1

But it doesn't seem like that line is intended to impact the inclusion/exclusion criteria. I totally understand if you want to move on with your life but would be interested in learning how each line is impacting the results.

Either way, thanks again!!!

Posting working code here for posterity:

Sub PopulatePartsListV3()
 Dim rng As Range, c As Range, LstRw As Long
 Set rng = Range("Y40:Y417")
 Application.EnableEvents = False
    For Each c In rng.Cells
        If c <> "" Then
            LstRw = Cells(Rows.Count, "F").End(xlUp).Row + 1
            Range(Cells(LstRw, "C"), Cells(LstRw, "M")).Value = Range(Cells(c.Row, "V"), Cells(c.Row, "AF")).Value
        End If
    Next c
 Application.EnableEvents = True
End Sub

Wow I never would have figured that out lol. Thanks again for your help and the lesson!

Sounds like very good advice and there is no reason why I could not have done that in this workbook. Thanks again for the lessons!