I have a query in that i have a three types of date which are in date format and there is different pivot charts for each dates i use calender object to select
From Date to To Date . But problem is that when i select From Date then all the values get effective in all pivot charts but i dont want that i make on button and apply a macro on that to get effective From Date to To Date in all pivot charts because in charts i use condition from date and to date variable.
Please provide help for that.
i tried that but i attach a small app for demo what i want please check and revert me with updates.