S
Steven
Hi
I created a little makro which generates a small amount of pivot tables and
graphs. The files I start from are generated on a regular basis using another
application (but the end resultsof that application are excel files).
The graphs show an evolution of different aspects but by default the graphs
I create from the pivot table always show the evolution of the combined
periods (All). I want to create my makro so that it automatically selects the
last available period for a graph (so without knowing the name of the period
since the analyses will be made at different times using different periods).
Can anyone help me with this?
Thank you!
I created a little makro which generates a small amount of pivot tables and
graphs. The files I start from are generated on a regular basis using another
application (but the end resultsof that application are excel files).
The graphs show an evolution of different aspects but by default the graphs
I create from the pivot table always show the evolution of the combined
periods (All). I want to create my makro so that it automatically selects the
last available period for a graph (so without knowing the name of the period
since the analyses will be made at different times using different periods).
Can anyone help me with this?
Thank you!