TrainTrainer
02-14-2020, 06:43 PM
I'm currently doing this with formulas and would like to automate it with VBA
25992
This is my format. Agent decision is what they assigned to the job, correct decision is what they should have assigned.
agent tagged a color but it wasn't correct - overtag
agent didn't tag a color but should have - undertag
For each tag I need to determine if the agent overtagged or undertagged that color, and put a number in that column. Then I need it to loop through all rows to the last.
I've googled this but not finding what i need.
25992
This is my format. Agent decision is what they assigned to the job, correct decision is what they should have assigned.
agent tagged a color but it wasn't correct - overtag
agent didn't tag a color but should have - undertag
For each tag I need to determine if the agent overtagged or undertagged that color, and put a number in that column. Then I need it to loop through all rows to the last.
I've googled this but not finding what i need.