Hi

I've been trying to find a way to write a VBA program to calculate the optimal solution for allocate projects to a number of different people based on their preferences, but I have had no luck.

For example, I have ten projects that need to be allocated to ten people. Each person states their 1st, 2nd and 3rd preference which are then turned into scores (1st=30, 2nd=20, 3rd=10).

The objective is to allocate the projects to people in such a way that maximises the overall score. So, for example, if everyone was allocated their 1st preference the total score would be 300 (the maximum possible).

What I have been trying to create is a VBA program that could determine the optimal allocation of projects based on preferences, generating the highest total score, which ensured each person was allocated only one project each.

Any ideas would be most welcome!

Thanks
Matt