Provincial Economic and Financial Statistics in Indonesian Statistik Ekonomi Keuangan Daerah (SEKDA) are monthly statistics published by Bank Indonesia containing economic, financial and banking data at the provincial level throughout Indonesia. The data/statistics enable users to observe economic, financial and banking developments in each respective province of Indonesia.
As of now, it's quite tedious to manually select range for table of a given file (unchanging) and then paste it into word as a picture, the work itself will take so many effort and time to do, aand in some case you also need to readjust and hide spesific range just to include the heading for specific use.
With this vba script you can just do it automatically and also update it using excel dashboard that being provided as it is.
As part of my curriculum, I need to do internship and I was given the opportunity to take part on Maluku Province Bank Indonesia Representative Office for 5 months, with the first 2 weeks I was given a task to help increase the productivity and digitalization of Fungsi Data dan Statistik Ekonomi dan Keuangan (FD-SEK) especially the part when they need to make a report in the form of a Book, which is named Provincial Economic and Financial Statistics or in Indonesian Statistik Ekonomi Keuangan Daerah (SEKDA).