Excel Macro Tutorial 5 – Delete cancelled tests, flag credited tests
When a test is cancelled in the system it appears as a charge and then a credit with the same date and time.
The billing team does not want to see these, as they have to charge for a test and them immediately credit a test, and it’s a hassle. So we clean them up before submitting.
Often a test gets ordered, cancelled, and then re-ordered, so it is important to make sure the code doesn’t delete the re-ordered test: …