I been surfing the web and trying to figure out a formula to solve a work issue i'm having. I have a spreadsheet everymonth that contains about 10,000 lines in it. I would like to get a VBA together to help make the sorting process easier. I want it to sort by Column B which contains the account number, but i want it to only sort by the first 6 digits of the account number. Example :In Column B, 030-445-4955-49449-000 , but i would like the sorting to be done by 030-445. The first six digits represent a department within my company and the last digits are their expense line. I found this code on-line, but it takes all the different account number in B and sorts them. Can anyone help me tune this code to me needs? Thank you in advance.
Bookmarks