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...
Macro for automatic overview of yesterday (with slicers, pivot table and pivot chart)
KriCo
1
Reputation point
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 ?
{count} votes
-
Viorel 89,061 Reputation points2021-06-23T04:36:00.51+00:00 Does it work if you manipulate this sheet manually, not by macro?
Sign in to comment
1 answer
Sort by: Most helpful
-
KriCo 1 Reputation point
2021-06-23T07:12:23.567+00:00 Sign in to answer-
Viorel 89,061 Reputation points
2021-06-23T14:30:34.907+00:00 Did you investigate the values of .SlicerItems(i).Name and variables, and did you check if the condition .SlicerItems(i).Name <> myDay works as expected?
KriCo 1 Reputation point2021-07-01T07:49:10.637+00:00 Hey,
I added the file. Maybe you can test something ...
I tried everything in range of my knowledge, but i don't know what to do anymore ...
So i hope somebody can see what i did wrong ...
Sign in to comment -