Rearrange Data

[Burt_100]

I'm not sure if this can be done or not, I need code that will prioritize data and delete if necessary, I need the data in range M2:V to be looked at and if anything in row is evident delete, so for example if the data sequence is D52, D52, D54, D56 I need the data to delete the D56, I have attached a workbook with these examples, The list of priorities starting with the highest are; D54, D55, D56, D58, D61, D60 so if any of the list is before D54 in a row it should be deleted and for example if D56 is evident after D61 then D61 should be deleted.
Thanks in advance

[dflak]

You are going to have to explain this better or maybe in a different way. Why is D56 deleted in your verbal example?

On row 7 there is no D56, yet there is one on row 36. Howe did you get from one to the other?

[Burt_100]

OK, Sorry for being unclear, Ill put it this way, if for example in row 3 there are 4 entries I D52, D54, D52 & D55 the I would want D55 deleted as it is after D54 on the priority list or if in row 5 there is D52, D61, D56 then I would like to delete D61 as it is in front of D56 on the priority list, Does this clear it up?

[dflak]

I'm still not getting it.

Here is what I think you are saying: look at the current value and look at the next value. If the next value is less than the current value, delete the next value.

[Burt_100]

Yes thats correct, Look at the value and if D54 is in the list then delete everything after it and so on dependent on the priority.

[dflak]

Here is the code, however you will have to modify it. The list of priorities in the description is different than some of the codes on the worksheet. For example codes D51 and D52 are missing.