VBA Macro: Sorting Alphanumeric values

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.

Use an additional column to extract the last 3 digits and sort on that...