VBA Sorting

[ElvinK]

Hi all.

I have table which specifies the repair, the sequence (aka the priority) and the workstation as shown below.
Is there anyway a VBA code will be able to help me sort the repairs in order, by grouping repairs done at the same workstation together, while maintaining the sequence within the repair itself.

The first table shows the before and the second table shows the possible result.

The logic should be somewhere along the line of:
1. Using the repair with lesser processes as the reference , in this case, the repair highlighted in green.

2. Taking the first repairstation scheduled for that particular object as a reference, do a loop down to find in the other object repair (highlighted in yellow) if there is any repairs to be done at the same station.

3. If answer is yes for 2.,cut whatever that above the particular row which consists of the similar workstation and paste it above the reference repair (green) which was used as a reference in 2..

4. Continue loop and move of to the second unique workstation found in object A (green) and repeat steps 2 and 3 until all unique workstations have been accounted for.

There is a possibility to have more than 2 objects as well.

Will really appreciate any contribution of help.
Have been troubled by this for many many days.

Untitled.jpg

[Leith Ross]

Hello ElvinK,

I follow you logic for the first 2 objects, but the third appears to be inconsistent. Shouldn't Repair 03 for Object A Room C be below Repair 02 for Object B Room C?

[ElvinK]

HI Leith Ross,

Repair 03 for Object A Room C cannot be below Repair 02 for Object B Room C. All repair for any particular object must obey the "Priority", specified in the second column.