Creating Automation Report inside your

Hello and a very good day everyone,

In this video, I explained on how we can automated monthly report.

Sometimes, we do have work assignments where we do update monthly data such as employees claims, inventories listing, expenses report etc.

There are situations where we do the work task manually.

Therefore, in this video, I have educate you on how we can automate the work so that in future you can update the data automatically

The files for this video is monthly claims of employees report.
You refer to the attached files in the google drive link shared below :
https://drive.google.com/file/d/1t6_Q...

To automate the monthly report :
1. First you have to consolidate the files using Power Query. You may refer at 00:50

2. Next, you can use Pivot Table to generate exciting dashboard (visualisation). You may refer at 06:18

3. Lastly, you can try to use a VBA to automatically refresh the data.

The VBA code is as follows :
Sub Update()

Dim abc As PivotTable
Set abc = Sheets("Claims").PivotTables("PivotTable1")
abc.RefreshTable

End Sub

Disclaimer : Please check the vba code in order to ensure it is accordance with your file

You may refer the VBA part at 09:18

Thank you very much everyone. I hope you can watch this video. Do let me know if you have any inquiries or clarifications. Should you have any questions, feel free to drop your questions on the comments section.

Thank you and have a great week.