Copying data from one sheet into multiple sheets

  • Hi Everyone,


    I'm pretty new to VBA and I have this task to do, but it seems that it would take me quite some time to be able to pull it on my own using VBA. I need your expertise to solve the following.


    I have one sheet that contains all the data. I want to copy the data inside that sheet into multiple separate sheets, according to one column, with all the rows of data related to it.


    I want the data related to column A to be copied into separate worksheets for each account number e.g "cell A2" with all the rows below it into one sheet (from A2 to A6), and for next account number "cell A7" to put into a separate sheet as well (from A7 to A11)to do the same for all the values in column A


    I hope i made my request clear. Thank you in advance

  • Hi Everyone,


    I'm pretty new to VBA and I have this task to do, but it seems that it would take me quite some time to be able to pull it on my own using VBA. I need your expertise to solve the following.


    I have one sheet that contains all the data. I want to copy the data inside that sheet into multiple separate sheets, according to one column, with all the rows of data related to it.


    I want the data related to column A to be copied into separate worksheets for each value in column A, e.g "cell A2" with all the rows below it copied into one sheet, (rows 2 to 6) , and for next value "cell A7" to copy the rows data (rows 7 to 11) into a separate sheet as well, and so on for all the values in column A

  • Thanks for your file :)


    In order to work properly with Excel, you should avoid viewing your spreadsheet as a word processor ... and build a proper database ...


    If you want to learn Excel Efficient Worksheet Design,


    Would suggest :


    https://www.ozgrid.com/Excel/E…eadsheetDesign.htm#Layout


    Hope this will help

    :)

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

  • Hello again,


    To give you an idea of the very first step ...


    Attached is your test file with a macro to get you started


    Hope this will help

    :)

    Files

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

  • Thank you for tips!


    Basically, the worksheet I sent you earlier is a combination of two worksheets "Acct Balance",& "User line item" in the attached file. I think both are quite organized as data sets.


    The desired outcome of the combined data, is to copy the data for each unique account number into multiple worksheets, one sheet for each account; using VBA I suppose, since I cant figure it out any other way.

  • Thanks for your Thanks :)


    You do not need to adjust the range size ... since it is been done by the macro ...;)

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

  • By the way, forgot to tell you, if you face difficulties at transposing the macro to your real-life workbook...


    you should not hesitate to come back to the Forum ...

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