Sorting based on a particular column to determine a logical sequence

Problem Statement: I have a table containing 3 columns(Task#, Duration & Task Priority). I have to sort the Task# Column based on the below requirement.

Note: Working Hours per Resource per Day - 5 Hrs. All resources should be equally assigned with work.

1. Given a set of 4 resources, I have to allocate the below mentioned task to these resources on priority basis.
2. Eg. The Task Sequence should be sorted in such a way that the Priority 1 should be completed on Day1 with 4 Resources working 5 hrs per day.


Input Table:
Task # Duration(Hrs) Task Priority
Task 1 5 1
Task 2 5 1
Task 3 5 1
Task 4 5 1
Task 5 5 2
Task 6 5 2
Task 7 5 2
Task 8 5 2
Task 9 5 3
Task 10 5 3
Task 11 5 3
Task 12 5 3


The sorted output should be

Task# Task Priority Task Duration Resource Day

Task1 1 5 Resource1 Day1
Task5 2 5 Resource1 Day2
Task9 3 5 Resource1 Day3

Task2 1 5 Resource2 Day1
Task6 2 5 Resource2 Day2
Task10 3 5 Resource2 Day3

Task3 1 5 Resource3 Day1
Task7 2 5 Resource3 Day2
Task11 3 5 Resource3 Day3

Task4 1 5 Resource4 Day1
Task8 2 5 Resource4 Day2
Task12 3 5 Resource4 Day3



This task list is dynamic and I might have hundreds of task each having different priorities and duration. Pl suggest a vba solution to this problem.

Thansk
Vijay