Hi,
I am currently attempting to write a macro, and running into some roadblocks.
The macro I am writing needs to take data from my company's third party verification system, and sort through the data. Specifically, I need to verify which accounts failed the verification system, so that we have those entries documented for another report. Sometimes accounts need to be run through the system multiple times due to human error. The issue I am facing is this: How can I write a macro that will detect duplicate entries, and each entry for an account number with a pass result? I basically think the macro should do something like this, written below in pseudocode:
If (for each account number) there is (an account "Pass")
Then (delete all entries for that account number)
End If
Does anyone have any advice on how I could try to write this? Thank you!
