So, I get a list of phone calls each day from a partner that I need to review. I only have to review 30% of this list. What I would like to do is to write a macro that will look at the column with the agent id and delete the row anytime there are more than 2 entries for that agent. I have no experience with VBA and have been having a hard time finding true square one tutorials (I will be looking through the sticky on this forum as soon as I am done here). Below I will list what I would like the macro to do, I was hoping someone would be willing to translate it into VBA for me.
Thanks,
---------------------
Select all rows
sort by column s
row number = x
for each not empty row in the workbookif sx<cell value> = s(x-2)<cell value>delete contents of rowelseselect all rowsdo nothing
sort by column s
Bookmarks