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 ?
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 ?