title: How to allocate rows to a list in excel
body: <p>I wanted to allocate the work to the number of people that can work on the task.</p>
  
  <p>From the left table (raw data), I will input the names of the available workers. Then as a result, right table, the 5 people was then allocated 3 each. The work for each person is determined by the user, <em>(much better if it will be automatically calculated to be allocated to each person equally, eg. 10 workloads to 5 people = 2 workload each, 100WL to 5P = 20WL each, and so on. hope you get the gist)</em></p>
  
  <p><img src="https://i.stack.imgur.com/pNYRm.png" alt="enter image description here"></p>
  
  <p>I am not familiar to excel, the processes and computations that it can do, but I am familiar to VB6 as it seems to be the backend coding of excel, so I will go down the coding path to execute this command. If possible, it will be greatly appreciated if one can provide me a sample in excel, so I can study, edit and tweak it a tad better as I am new(first time) to using VB6 in excel.</p>