I am loading a bank statement into an array and I want to load the data into a spreadsheet that has the transactions for the financial year.
The first file of the year loads the statement into an array and then outputs into a sheet. I was hoping the subsequent file could be loaded into an array and then I would load the existing financial data into another array. Compare the two and find those transactions that only exist in the new file. I could then output the data into the exist spreadsheet, avoiding duplicates. I had thought I would load the difference into an array and then output it.
I figure if I compare the transaction date, amount and description, where I can't find a match I would then write the record out.