I have ref numbers in Col A and values in Col B
where the debit and credit values match within one row of each other and the ref no. is the same or the ref contains the text Reverse in the aame row as the credit value, then the rows containing these items are to be deletes for eg B2 is 100 and B3 is -100 and the ref A2 is KB-965 and A3 is either KB-9654 or contains text reverse then these rows are to be deleted
It would be appreciated if someone could provide me with code to do this
See sample data below-The rows in yellow are to be deleted
where the debit and credit values match within one row of each other and the ref no. is the same or the ref contains the text Reverse in the aame row as the credit value, then the rows containing these items are to be deletes for eg B2 is 100 and B3 is -100 and the ref A2 is KB-965 and A3 is either KB-9654 or contains text reverse then these rows are to be deleted
It would be appreciated if someone could provide me with code to do this
See sample data below-The rows in yellow are to be deleted
| Book1 | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Ref | Value | ||
| 2 | KL-8030762 | -98,707.98 | ||
| 3 | KL-8030762 | 98,707.98 | ||
| 4 | KL-8030763 | -92,105.26 | ||
| 5 | KL-8030763 | 92,105.26 | ||
| 6 | KL-8035 | 136,842.11 | ||
| 7 | KL-8038 | 86,956.52 | ||
| 8 | KL-8039 | 360,989.20 | ||
| 9 | REVERSE ITEM | -360,989.20 | ||
| 10 | ||||
Sheet1 | ||||
Last edited:
