Analysing voting preference - using VBA?

I've done something similar in the past, but for a many-to-many assignment instead of one-to-one.

Given 30 employees and 50 tasks, assign a team of 15 people to each task. Each employee rates each task as 3/2/1 (reallwanto/ratherbeboiledinoil). So each employee was assigned 25 of the 50 tasks.

Assignment Round: Starting with the most senior employee, identify his highest-preference tasks among those remaining (i.e., for tasks that are not yet fully staffed). For each task at that level, identify the one that has the lowest preference among all other employees, and assign him that one. Proceed in round-robin fashion until all tasks are assigned.

Swap Round: For every employee and every assignment, compare preferences. If swapping the assignment made either employee 'happier' without decreasing the happiness of the other, swap. Repeat until no swaps occur.

The approach worked very well for me, based on the 'happiness quotient' -- a measure of what people were assigned to compared to their optimal assignment.

The rigorous solution for your 1:1 problem is called maximum weighted bipartite matching in graph theory. Lots of literature if you Google.