Hi to all, I need help please. Kindly download and see workbook first so you can know my problem, I need to find the "Account" Number in "Raw" Tab, list of Account number are in "Find & Separate" tab, I just set 3 account number only for my example but in reality I have to separate 400 account number. On Raw tab each account number has details below of them before the next account number. Each account number must copy and create tab and the name will be the Account number itself. Can i know how to create a VBA macro code for it? so I don't have to manual 400 account number,for clarification kindly send reply on this thread, Thank you so much in advance to those who are willing to help
.
PS: The occupied column per account are not fixed(see Raw tab), if see the workbook some account occupied only column H or I.
Bookmarks