J
Jim
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
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