I want to just input who in attendance, and the number of pulls needed in each dept. (dept.#doesn't change), and have excel throw the associates into departments so that they all pull about the same total amount of items, and so I know the totals for each employee. And also if they pull from dept. 4 or 9 then that's all they pull from.
i.e
Working today: Mike, Dave, Janet, Jill, Josh, Ed
Dept Pulling Name
3 45 Dave
4 234 Janet
5 37 Ed
6 34 Dave
7 65 Jill
8 45 Josh
9 115 Mike
Total being pulled by Dave 79
etc.
Bookmarks