Hello,
I'm working on a spreadsheet with close to 1 million lines. I need to match debits and credits in order to determine if incorrectly entered data lines have been fixed. There are some debit and credits that have 10 or twenty entries of the same amount so I need to only match the debit and credit amount that have matching 4 columns. Also, there are varying situations... in some instances there could be an 2 credits and 3 debits with all matching criteria, etc. I need to only highlight the debits and credits that sum to zero, that way I can determine which lines still need to be corrected.
I borrowed a macro from on here and tried to adjust some of the code, but no luck! I've highlighted the columns that need to match and highlighted row 52 and 53 as an example of a debit and credit that I would be trying to identify. Thank you!
Bookmarks