A
aston75
Im posting this in word and excel forums, because I use
both of these programs in this task. Id like to reduce a
task which currently takes a while of 'stuffing around'
to something quick and easy.
I use an internal work program and work in an office
where about 150 people come in each day and we need to
put down a written result (unavoidable! ) for each
person. Basically what spits out from the system is a
list of names which can be opened by excel. After
organising into alphabetical order, some people appear
once (Which is what i want), some twice, 10 times and
even 50. What I want to do is to be able to reduce the
list to one name/entry for each person, so that I can get
a list of people each day, without the need for tedious
deleting of names and rows. Does anyone know if there is
a function in excel or word to do this (thus deleting
duplicate names)?
Basically each name then goes into a result sheet, I
currently paste from excel into word, (where results are
written in, in pen) to see what has happened with this
people on the day. I'd like to be able to get this list
and put it into word as quickly as possible. It's
basically a table with number of the person on the left,
the persons name, then a space for a result, with a
heading with date and things on the top. Can anyone help
with an easier way to organize all this? Previously,
people would physically type each name out from the lists
from our internal program, but I know there would be an
easier way.
Thanks for any help. cheers
both of these programs in this task. Id like to reduce a
task which currently takes a while of 'stuffing around'
to something quick and easy.
I use an internal work program and work in an office
where about 150 people come in each day and we need to
put down a written result (unavoidable! ) for each
person. Basically what spits out from the system is a
list of names which can be opened by excel. After
organising into alphabetical order, some people appear
once (Which is what i want), some twice, 10 times and
even 50. What I want to do is to be able to reduce the
list to one name/entry for each person, so that I can get
a list of people each day, without the need for tedious
deleting of names and rows. Does anyone know if there is
a function in excel or word to do this (thus deleting
duplicate names)?
Basically each name then goes into a result sheet, I
currently paste from excel into word, (where results are
written in, in pen) to see what has happened with this
people on the day. I'd like to be able to get this list
and put it into word as quickly as possible. It's
basically a table with number of the person on the left,
the persons name, then a space for a result, with a
heading with date and things on the top. Can anyone help
with an easier way to organize all this? Previously,
people would physically type each name out from the lists
from our internal program, but I know there would be an
easier way.
Thanks for any help. cheers