Excel Macro Tutorial 4 – Delete non-chargeable tests and sort.
The billing report has a bunch of tests with at cpt code of ‘0’ or a blank. These are non-chargeable tests. We used to have to delete them manually.
For this we can loop through the rows and delete non-chargeables just like we did with the junk removal. For efficiency we could just add this code to the junk-removal macro, but I have kept them separate here for the sake of simplicity. I called the macro ‘DeleteZero’ and copied and modified from the last macro: …