Vba sort list

[ch_abs]

Hi All,

I have a list that looks like:
Capture.PNG

The list starts from column O and can run across to column Z, and the numbers in the list go up to 89.
When I sort the cells in Excel by O, then P, Q...etc then I end up with a list like I have shown above.

This list is to show dependencies of jobs. Therefore, on the row where the dependencies go '1,2,3,4,5,6,7,8,9,10' I'd like to see it sorted so that it comes under the dependency '10'.....because how can I run a job just after job '1', when it dependends on '1,2,3,4,5,6,7,8,9,10' being complete aswell!

Below is the code I have attempted and attached is an example workbook to work with. I have a few MsgBox's just for de-bugging to try and help me figure out the problem..as you can see that didn't go so well! Also, (anyone who helps me - thank you in advance!!!!) save the workbook first...my code eats rows/makes them do a disappearing act...

Please Login or Register  to view this content.

Thanks in advance, I've been struggling a long time on this!