Macro Question

[jmessick]

Hello Once agian,
Heres my question I have a workbook that keeps track of agent that are monitored for qa this information is added to a "spreadsheet" I might have 4 monitors on 1 person total monitor is 4 and total persons monitored may be 1 I need to 1- sort the data by agent name then count how many monitors i did for that person

Monitors Completed 4
Average Score
Total Agents Monitored 1


I need to be able to have this data input total agents monitored in to a row. to total for end of week ??

Hard to explain with out looking at it i know.

thanks in advance

 

[voodoo]

It might help if you could show exactly how the data is entered in the spreadsheet. What you want doesn't seem hard but the coding would depend on how the data is enetered

For example is it like this

Name Monitor 1 Score Monitor 2 Score Monitor 3 Score Monitor 4 Score
Smith Y 75 Y 59 Y 74 N 98
Jones N N Y 85 Y 85

 

[jmessick]

In rows like this agent name is colum a sup is b etc etc
Agent Name Supervisor score
youname joe sup 99
youname joe sup 97

1 agent monitored 2 scores there is 33 colums in the sheet.
I hope this helps

 

[PaddyD]

Hard to explain with out looking at it i know.

download the html maker addin from the link below this post. You can then post a snapshot of your spreadsheet.

Paddy

P.S. Why didn't you just bump this thread back to the top by posting a reply to it, rather than starting a duplicate in another thread?
This message was edited by PaddyD on 2002-08-29 16:49

 

[jmessick]

I cant install stuff at work I can do it when i get home tonight

 

[Aladin Akyurek]

On 2002-08-28 01:35, jmessick wrote:
In rows like this agent name is colum a sup is b etc etc
Agent Name Supervisor score
youname joe sup 99
youname joe sup 97

1 agent monitored 2 scores there is 33 colums in the sheet.
I hope this helps

I don't know why you mention 33 columns...

You should indicate how one knows whether an agent is monitored or not.

 

[Aladin Akyurek]

P.S. Why didn't you just bump this thread back to the top by posting a reply to it, rather than starting a duplicate in another thread?

I believe the OP intuited a possible solution up there...

 

[PaddyD]

& I suppose he has got some attention now!

 

[jmessick]

Live this:
Sub sort_it()
new_name = InputBox("Name Here please")

'find bottom
Set basecell = Range("A1")
Range("A65536").Select
Selection.End(xlUp).Select
bottom = ActiveCell.Row

bottom = bottom + 1

' assigning variables
name_to_sheet = "a" & bottom 'location
number_to_sheet = "e" & bottom 'location
value_to_sheet = 1 'value

' putting variables into sheet
Range(name_to_sheet).Select
ActiveCell = new_name
Range(number_to_sheet).Select
ActiveCell = value_to_sheet

' looking to see if there is a matching value
counter = 1

Do While counter < (bottom - 1)
mark = basecell.Offset(counter, 0)
If mark = new_name Then value_to_sheet = 0
'if there is a match then...
If value_to_sheet = 0 Then
Range(number_to_sheet).Select
ActiveCell = value_to_sheet
Exit Do
End If

counter = counter + 1
Loop

End Sub