Hi,
I have thousand of data with different account numbers. Each account have more than 10 records of purchasing. I need to pull each data into different workbook based on their account no. Noted that each account no will have different workbooks. Can anyone help me to get the idea of do it.
Tq
Hi DoodahSarsoorati, please upload a sample workbook. Thanks
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thank you..btw i already managed to solve it but now need to enhance more..I managed to split the data based on their GII5NO. Now i need to separate each GII5NO data based on their REBNO.Originally Posted by wenqq3
1. Each GII5NO will split into different workbook
2. In each workbook it will split into different tabs according to REB1,REB2, and REB3.
Here is my attachment.
Call this when you split data to new workbook
Please Login or Register to view this content.
Its really help me yeayy..it run exactly like what i want..TQ so much u save my lifeCall this when you split data to new workbookPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks