Sort Data based on multiple values

[thelegazy]

I want to be able to organize the data based on certain values. I want to sort it based on the following priorities from column "I":

1. Run (If there is more than one of this and the following two, sort by the earliest schedule start date)
2. Interrupted
3. On Machine
4. Everything that doesn't have any of the following, sort them by the earliest schedule start date in Column "C"

I have attached the dummy data.

I have the following code which I got from recording the macro, but I can't seem to understand how to incorporate it with another code I have.

Please Login or Register  to view this content.

I want to be able to incorporate it with this code, but I cant seem to get it to work. I also don't know how to change the ranges so that it covers all the columns:

Please Login or Register  to view this content.