We need our reporting dashboard works as designed.
It will be used to track and monitor the progress of several projects we have in some regions.
It should be able to monitor several milestones e.g: 70%, 80%, 90%, and 100% of each timeline whether it’s set to Baseline, Forecast, or Actual.
Because of the limitation of the screen and the Designed Layout Format, we would like to show the Clusters in First 18, Second 18, etc…
The named ranges referring to those data which need to be populated should be dynamic and can be changed as variables based on auto creation from its headers of each columns of those data.