I have a financial journal with three basic columns.
The journal is populated from the accounting system and contains entries which are not known to the capturer and threfore puts all unknown entroies (debits and credits into this Journal.
Once the entry is resolved, say it was a credit then the account gets debited in this journal and credited in the correct one. Now we have the same value in debit and in credit. I would like to run a vb script to identify duplicates in the two columns and the delete both rows.
I have tried it but when I go into the first column Put the value into variable, go to the next column anf find the same value. If Found the row in the second column is deleted then return to the first column and delete that row. My problem was whenni got to a nill cell in the first column the script seized
Can you give me basic guid line