Tracking Finances with VBA

[Jeffrey Lebowski]

Hi everyone,

I have made a new years resolution to keep track of my finances. What better way to leverage Excel and it's capabilities with VBA??

I am able to download account activity into csv files from my banking website. I am writing vba to take the raw extract file and format it to my liking, and add it to a running log of my finances.

Part of the formatting I need help with is the column for the amount of each transaction. This column includes both positive and negative numbers. I want to take this column and split it into a debit column (positive) and credit column (negative).

Please see the attached file.

Thanks for your help!

 

[NARAYANK991]

Hi Jeffrey ,

Can you not use an IF statement ?

Check the file.

Narayan

 

[SirJB7]

I have made a new years resolution to keep track of my finances.

Hi, Jeffrey Lebowski!
So did I... but with formulas only. Give a look at the uploaded file.
Now I have my problems solved at least until end of year 2023.
Regards!

 

[Jeffrey Lebowski]

I don't know why it didn;t occur to me to use the IF function....that is the ideal solution.

Thank you both.

 

[SirJB7]

Hi, Jeffrey Lebowski!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!