I have been on a mission to get my financial life to stay in the green, it's been in the red
so much because of my inability to track my money. What I have came up with is an Excel sheet that looks and acts exactly like a checkbook register.

a1=date B1=refrence C1=description d1=debits e1= cleared f1= credits g1= balance

Starting in g3 through end of that that colum I use this formula =G2-D3+F3 to do my
calculations, I only have to fil in a, b, c, then either d, or f depending on the transaction. All this works well but I have to sit and go through each transaction online and enter "C" in colum E of my sheet to mark each item cleared or not, either way colum G will still show me the actual balance since it doesn't matter if the item is clear or not.

What I am trying to do is come up with an Excel formula to read NOT import data from a .csv file and compare it to my sheet. I can download my statement in .csv format that looks like this when opened with Excel.

a1=date b1=refrence c1=description d1=amount e1=cr/dr **the cr=credit and dr=debit.

If I could get a macro that would allow me to select the .csv file I downloaded then scan it
for matching credits or debits on my spreadsheet and if it finds one then automaticaly put a "C" in my spreadsheet colum E next to the matching transaction then I wouldn't have to go through it searching for the matches myself. I make more mistakes than humanly possible when I try to do this.

Is anyone available to help me come up with such a macro, I would greatly appreciate it and I wouldn't be less than broke all the time.