Posts by JLL909

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    crossposted: https://www.mrexcel.com/board/…o-rows-using-vba.1206336/

    Hello fellow VBA users,

    I have an issue and I'll really appreciate some help. I have this VBA code but I'll like it to count the number of occurrence (same name etc) within a specific column (A1) and copy the entire column and its row content on to one new row below.

    The VBA code I have prompts the user to select the area that needs copying and I'll like to eliminate that.

    I have added the VBA code below.

    I have also attached a mock example of before and after results.

    Thank you!

    -------------------------------------------------------------------------------------------------------------------------------


    Before:


    After: