How can I distribute 200 items into 14 employees?

I been working on excel sheet that will distribute 200 items between the employees that are available to work.
I've attached a copy of the workbook. First I need to look at the quantity of employees I have working that day. Second Distribute the items to each one of the employees. Third give the first employee the first piece. Fourth give the next available piece to the last person with a zero piece in their list. I will appreciate your help in this matter. I've tried many ways but I can seem to get it right, I've little to no experience in excel but what I've done needs tweeking.
Thanks a lot.

I can't see a workbook, try and post it again.

That file seems corrupt, a warning about undreadable content comes up in Excel and it won't open. I don't know if it has anything to do with it being zipped but you could try posting it with out zipping it first. That's how it's usually done anyway.
Also, instead of modifying your first post, make a new post in this thread with the file.

I am also very impressed by your solution, JR DHONA.
However, I don't understand much of how it works, could you please explain the logic behind it?

I played around a bit with this before I saw your post about adding time. I'm not sure what you mean but I made something, see if it works for you.

I somewhat came up with the time per piece with the format that JR DHONA has for us, but I came across another criteria the is as follows. Thank You Jacc for your help, I'll uploaded and review it.
1-1280 items
4-25 employees
13 minutes per piece
one hour of inactivity
Printed report by employee
Evenly distributed
Distribute in an order the items are going to ship
I used some of the basic formulas, because I have low experience. I know it could be a lot
better. Let me know what you think guys. Thanks a lot for your time

That's a long wishlist you got there. It seems like you need someone to develop a complete VBA spreadsheet solution for you, not just solve a few formula problems. I'm not sure I am willing to spend that many hours working on your project but I will try and give you some feedback on the list. Also, have you considered the Commercial Services here on the forum? http://www.excelforum.com/the-water-...-services.html

1-1280 items
4-25 employees
Already these two requirements would make me start using VBA to solve it since it would require adding and deleting both rows and columns.


13 minutes per piece
Same time for all different items? Then I think the solution I posted is almost overkill.

one hour of inactivity
This would not really be part of the distribution, would it? You could just add it to the total times. I'm not 100% sure of what you mean but this one doesn't sound too hard.

Printed report by employee
This is probably a VBA task since number of employees will vary so much.

Evenly distributed
This is solved in a way. However, if there will be some VBA code to solve the problem with varying amount of employees and items then it could make sense to code the distribution in VBA as well.

Distribute in an order the items are going to ship
Could be as easy as adding a column with shipping time and then sort by shipping time before distributing it but I'm not 100% sure of what you mean.

You should probably start a new thread and ask for help about coding varying number of employees and items and see how that works out. In that thread, post a workbook, explain properly what you want and provide a link to this thread.
Good luck!