Posts by Kar300z

    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.

    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

    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