Hi,

The problem is as follows:

There is a table with data in it. There is one column (B) called "Entry Count" that has numbers between 1-50.

The goal is to distribute each row to certain employee as equally as possible on the basis on the entry count. So at the end, when each row of a table has been appointed, all employees have equal sum of the Column B values.

There can be any number of employees between 2-15


I thought that one way would be to sum total values for each employee each row and then assign for the next row the employee that has the least points. But I've got no idea how to do that in VBA.

Any help will be appreciated. Thanks in advance.