It forms a monthly report that will be built in also to provide an adhoc report function as part of a larger data migration macro. It also has to be applied to 36 different pages covering a year across three categories: doing a script that can then be applied to each page is the simplest way of doing it.

The current manual process takes several hours a week to do, an automated solution is definately the way forward.

This part of the script is only a small part of the complete project.