Hi. I would be very appreciative if someone could point me in the right
direction. I'm trying to do something with excel but not even sure if its
possible.
I have a simple spread sheet that has 3 columns. 1) Policy number 2) Work
type 3) Allocated. What I have is a list of work that I want to distrubute
fairly between my team. The different work types have different levels of
difficulty so I'm trying to distribute the work types evenly between my team.
Currently I am filtering the work and entering the initals of the team member
in the third column. I enter the initials manualy. With over 500 items this
is taking some time.
Ideally I would like to declare a list of workers and if possible how many
pieces of work I want to allocate to them ( some may only work a half day ).
I would like excel list the work in order of type (this is entered randomly),
to populate the 3rd "Allocated" column with the workers initials, starting at
the top of the list and working down until the maximum number of allocations
is reached for each individual.
I'm happy to work on the details but dont know where to start. Any help
would be very much appreciated. I hope this makes sence.
--
Cheerie