Hi,
I want to sort the project nos. which contains numeric-alphabet-numeric value such as
2015AA001
2015AA003
2015AA004
2015BA002
In the above examples, while sorting; 2015BA002 is coming in last row instead of appearing in second row. Please help me with vba macro for arranging the project number based on last three digits only.
Bookmarks