Hi,
I have an Excel file which contains RM level details in sheet 1, and sheet 2 contains dashboard with pivot tables and slicers based on data in sheet 1. The dashboard is at pan country level, however I want the same dashboard for each RM with exactly same settings (slicers, formula, pivot tables etc) as country dashboard.
There are more than 100 RMs in sheet 1 data.
How can I create same dashboard for each RM, without creating separate copies for each RM manually. Pls guide.
I have an Excel file which contains RM level details in sheet 1, and sheet 2 contains dashboard with pivot tables and slicers based on data in sheet 1. The dashboard is at pan country level, however I want the same dashboard for each RM with exactly same settings (slicers, formula, pivot tables etc) as country dashboard.
There are more than 100 RMs in sheet 1 data.
How can I create same dashboard for each RM, without creating separate copies for each RM manually. Pls guide.
