Copy Non-Blank rows in a Range and Paste

  • Good to hear some progress has been made ...:)


    The current macro only checks the cells in Column Y ....


    For example, now that you have deleted the contents of cell Y224 ... the whole row is excluded from the process ...


    Isn' t what you had requested ...???


    If Not ... What should be the role of Column V ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • 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:

  • Glad to hear ... there is finally a relief ... :)


    Let's dive a few seconds into the underlying logic ...


    In terms of Columns : your Source Range is 11 Columns wide from V to AF ... but you are using Column Y as your Reference or the Fourth Column ...


    When it comes to your Destination Range which starts in Column C till Column M to cover the 11 Columns required, the Column to be used to identify the Last Row has to be ( like the Source one ) the Fourth Column ...i.e. Column F ...


    Hope this clarifies

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Thanks again for your Thanks ...AND for the Like :thumbup:


    May be a small piece of advice for your future Excel workbooks ;)


    Do not try to combine in one single sheet ...BOTH your Input data AND your Output report


    Since you might create for yourself 'future' difficult obstacles ...:S


    Simplest solution is : to keep your data in a dedicated sheet , and build your output in another dedicated sheet ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)