Hello,
I have a macro that I am working on, and part of this macro sorts a group of project plans into several different cateogries. Then within these categories the project plans which contain a 5 digit numerical prefix project number and the name of the plan need to be sorted numerically in ascending order. I have tried this manually however it only sorts by alpha characters instead of the project numbers at the start of the alpha numeric string. I was wondering if anyone could give me any tips on a procedure I could use or how to go about solving this using vba. I have attached an example spreadsheet with tabs depicting the original format, manually sorted format, and the desired format.
example_Desired_Effect(1).xls
Bookmarks