Copy Area To Rows Using VBA

  • 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


    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!




  • try..

  • alansidman

    Added the Label Cross Post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!