VBA for Accounting management system (2016)

This project is using VBA to calculate wages for the factory workers monthly. User only need to key in how many that the worker have been produced per day with the specific input type. After that, user need to click the button to run the macro to do the tasks, then the system will return the total wages for the workers. In addition, this system will generate a report for the office staff to know about how much the cost ad how many materials have been consumed. This system have been applied two Ms Excel functions such Vlookup and Pivot Table to shorten the development time.

The purpose of this system is to ease the workload of office staff to complete the jobs faster and efficiently.

https://video.wixstatic.com/video/c78f45_204c092437e242b49163051a4b1a4223/480p/mp4/file.mp4