Sale Dynamic Dashboard with No VBA
Select the year and press F9 Key. The main function used to design this dashboard is INDIRECT(CELL(“address”)) used in AA1 cell on data and calculations sheet. The equally important is the function used in AB1 cell on data and calculation sheet to return one of the years value always. In order to make summaries of data, the functions benefited from are SumIf, SumIFS, Vlookup. To unprotect dashboard sheet go to Review Tab and Select Unprotect Sheet. There is no password.