nobody seem to have answer! pls help
 

Hi all , this is my first post . i am in a desperate need , hope someone can
spare some time for me and help a novice user like me.
I 've a sheet cotaining about 50 agents' name in a column. I need to track
the no of calls they make each day.


name Nov 01 nov 02 Nov 03
x 12 13 14
y 24 15 45
z 45 56 61
c 32 45 87
p 12 12 16

i update this sheet daily. now i give them some dollars(custom currency)
everyday based upon the no of calls they make.
The criteria is:
Highest calls made - $6
2nd highest calls made: $4
3rd highest calls made - $ 3
4th highest calls made :$2

Now theres another sheet where their names are written in same format. the
difference is just that instead of calls, i need to put dollars , if any.
I have formuale that do it for me but it makes the workbook very tedious and
slo. I want a macro but since i m not good at programming i seek help of any
of u.Pls tell me if this can be done and also where to paste the code and
how to play it? i shall wait and if u hv any queries lemm know.


Any help or sugestion appreciated!

Jim
India

nobody seem to have answer! pls help
 

With respect Jim

I suspect none has answered because your asking for a complete solution.
Usually posters questions address specific problems they have with code in
progress rather than asking fellow posters to develop a whole proceedure
with limited information to boot.


Can you write any code ? Have you used the macro recorder ?


Bets N10


"Jim" wrote in message
...

Hi all , this is my first post . i am in a desperate need , hope someone
can
spare some time for me and help a novice user like me.
I 've a sheet cotaining about 50 agents' name in a column. I need to track
the no of calls they make each day.


name Nov 01 nov 02 Nov 03
x 12 13 14
y 24 15 45
z 45 56 61
c 32 45 87
p 12 12 16

i update this sheet daily. now i give them some dollars(custom currency)
everyday based upon the no of calls they make.
The criteria is:
Highest calls made - $6
2nd highest calls made: $4
3rd highest calls made - $ 3
4th highest calls made :$2

Now theres another sheet where their names are written in same format. the
difference is just that instead of calls, i need to put dollars , if any.
I have formuale that do it for me but it makes the workbook very tedious
and
slo. I want a macro but since i m not good at programming i seek help of
any
of u.Pls tell me if this can be done and also where to paste the code and
how to play it? i shall wait and if u hv any queries lemm know.


Any help or sugestion appreciated!

Jim
India