Hello,
The report (re-)generation process can be absolutely automated, from the dataset importing up to the creation of the final report. Of course, using VBA code (structured, not simple macros). Apart of the report design file, I will need at least 2 sample dataset files and maybe more explanations on the required calculations or other data handling. One factor which can significantly affect the project's duration and/or my bid is the total number of charts used for the final report as well as the different chart types. My bid (both price and duration) is based on a usual average.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for both Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs and dashboards of any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
chriskerpini