Automatic data input
 

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

Automatic data input
 

So, you want to sort the list by the work difficuly, then alternate workes
down the line.
sounds like you'd highlight your three columns:
data - Sort - Work Type
In the third column, type in a worker's initials in the first row, next
worker in the second row, on down til you have all workers in the list.
select all of the initials, then move your cursor to the bottom-right of the
last cell. It will turn into a black plus-sign. Drag down to the bottom of
your list. that should do it...

"sylbaryn" wrote:

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