I would like to be a paper where the master spread through the activation of renal function (which will build), it automatically "imports" the latest performance figures of weekly excel files, and create / update a pivot table and graph associated with them.
I want the graph to display the chart performance over time. I also want the table schema, which shows the performance numbers are the latest week compared to the previous period.
The file of the weekly naming files to be attached to such examples.
You will need to build all of the functions listed above: Macro, pivot tables, graphs and so on.