Macro for allocation

Hi team ,

i would explain in a better its batch allocation based on number of actions batch no is in sheet1 coloumn A and count of action is in sheet 1 coloumn B
, In sheet 2 i have the agent names . Now we have to sum up the count of actions and based on the sum we have to divide it to no of users in sheet2
take their names and assign in sheet1 coloumn c .

Hope you understand.

regards
som