Can i make the column I want to loop a variable? (i,VARIABLE) instead of (i,2)

Hello! I have gotten a bit stuck and would appreciate anyone's help!

I have made macro which is a work assigner, it takes via an input box "x" amount of people in your team (maximum of 12) and looks at "y" amount of your tasks (could be 1000's), and decides how to assign them fairly

However, I have hard coded each loop to put the worker's name in column 2:

Please Login or Register  to view this content.

Is there a way to make this a variable based on an input box? example
cells(i,VARIABLE).value=nameofworker1

I did try to do this myself/googled but cant make it work. The other thing with my code is it is particularly long/cumbersome, I have coded for each scenario up to 12 possible workers, but as you can see below the code is long. So long that it wont let me post the full thing here so i have only posted below up to 5 of the cases Was there a better way of doing this? Thank you for your help!



Full code (because my work wont let me upload attachments:

Please Login or Register  to view this content.

Thank you for your help guys! Good to have the more efficient method and how to make the column variable, thanks