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...
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hey,
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 ?
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...