Macro for automatic overview of yesterday (with slicers, pivot table and pivot chart)

KriCo 1 Reputation point


I have a problem with my macro for automatic selecting yesterday (so tomorrow i want an overview of today, or simple day -1).
And this overview has to be in the setup like the attached picture "capture.jpg". So it's a worksheet containing slicers, pivot table and pivot chart.

My current problem is when i run the macro, i get the overview of the entire month instead of only yesterday.

I attached my macro in the picture "macro.jpg".

Could anyone help me with this ?

{count} votes

1 answer

Sort by: Most helpful
  1. KriCo 1 Reputation point

    Everything works when i manually select the date i want... So all the connections between the chart, slicer and table are working.

    The macro also work, but when i run the macro it 's selecting everyday before yesterday. Not only yesterday...