 This research demonstrates how automating manual reporting tasks in Microsoft Excel can improve efficiency and reduce errors. By using Visual Basic for applications, VBA, in Microsoft Excel, the authors were able to create a framework for automating manual reporting processes. This framework allowed them to save time and resources by reducing the number of steps needed to complete each report. Additionally, the automated process was found to be 1.36 minutes faster than the manual method, indicating that automation can provide significant benefits to small and medium enterprises. This article was authored by Muhammad Ahmed Calwar, Asif Nawaz Wasan, Muhammad Ali Khan and others.