hello,
i searched many site and forums but i couldn't find the correct solution yet. i have a table and two macros which is reference with months based on filter and i have a another sheet of pivot table if i select the months of filtering using macro and i run the source data is filtering but same time pivot table in other sheet its not filtering same time and i have to do manually in pivot chart then upfdating to pivot table and i have also main table has protected sheet if i click refresh button its cant be refresh on protected sheet so many of them struggle for this problems pls anyone can help to sort out this problems.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks