An excel formatted downloaded bank activity file contains duplicated data deposits from my job where the dates in column A are different dates but the company name in column B and the amount in column C and the bank file contains other bank transactions which have duplicates except for the dates. The VBA code sums transactions that consists of debits and deposits which are in column C according to the respective transaction names. For example, grocery debits accumulate in the Food label, medical bills and doctor bills in Medical label, etc.
Excel 365 skips the duplicates. It enters the 1st found and skips the duplicates no matter where they are in the Column B; right below the current found row or several rows down.
I switched to excel 365 because excel 18 working VBA files were acting up like MS wants me to switch to 365!
Thank you.
Excel 365 skips the duplicates. It enters the 1st found and skips the duplicates no matter where they are in the Column B; right below the current found row or several rows down.
I switched to excel 365 because excel 18 working VBA files were acting up like MS wants me to switch to 365!
Thank you.