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