Putting this all together is giving me a migraine. I’m sure this will be easy enough for most of you.
When I download activity from my checking account it arrives with five columns and x number of rows.
I put this data into a budget I created. I want to create a macro that takes the download and formats as follows
Column 1: NumberFormat = “MM/DD/YYYY”
Column 2: = (Determined by Column 4) IF value in column 4 <0,”DEBIT”,”CREDIT”
Column 3. Autofit
Column 5. Deleted
Column 4 : NumberFormat = “$#,##0.00;[Red]$#,##0.00”