Excel VBA Code for Sorting multple columns
Budget: £10 – £20 GBP
We want to automatically sort via VBA to reach the following outcomes:
1. Sort volunteers by project in order of: Project 1, Project 2, Project 3, NP
2. Within each Project # range, sort by highest amount of points
3. If any amounts are same, sort by earliest date
Context: This is to create a priority list. Project 1 volunteers have more priority than Project 2 and so on.
Within each project list, volunteer with highest points has priority. So for example Project 1 volunteer never will fall under Project 2 volunteer.
If points are the same for volunteers in the same project, sort volunteers by earliest date.
Final priority data should be in one sheet, one set of data, not separated. We want to use VBA so the update happens continiously and in-place
1. Sort volunteers by project in order of: Project 1, Project 2, Project 3, NP
2. Within each Project # range, sort by highest amount of points
3. If any amounts are same, sort by earliest date
Context: This is to create a priority list. Project 1 volunteers have more priority than Project 2 and so on.
Within each project list, volunteer with highest points has priority. So for example Project 1 volunteer never will fall under Project 2 volunteer.
If points are the same for volunteers in the same project, sort volunteers by earliest date.
Final priority data should be in one sheet, one set of data, not separated. We want to use VBA so the update happens continiously and in-place