FINANCE AUTOMATIC STATEMENT VBA

Statement sampleEmail Sample

 

 

 

Description

Finance had been spending a lot of time in grouping customers, making customer statements and sending emails to customers. After understanding the work process, I have built a VBA programme and used power query, all these things can be done within 10 minutes, rather than a couple of days. The process is now standardized and automated.

 

Technology

 

Some VBA code