Sort data in specific alphanumerical order

Hi,

Attached book shows a sample data I need to sort. Excel's built-in sort (A-Z), will render the result shown on Sheet 1, but I need the data sorted as shown in sheet 2 (I don't need the data moved to a new sheet, I just put it there to make a separation). What I mean, is that entries are sorted not based on the first numeric value after the "-", but rather, in the number of digits after it. (I highlighted the records needed to be re-sort on Sheet 1 for easier identification, but I don't need them to be formatted as such).

What's the best way to achieve this?

Also, every sheet I will be running the macro at, will have a different name and there will be no "Sheet 1", but rather, whatever name the sheet comes with from my colleagues.

Thanks for your help.

I added a couple of helper columns and then did a multilevel sort on Column B then Column C.

Sorry see now that you want a macro.

If you wan t sort by the number with e same prefix

Please Login or Register  to view this content.