Notifications
Clear all
Topic starter
..........I wish to make a single dashboard (interactive sheet) based on the previous sheets. So that at the click of any subdivision the rest of the data (B to H) is displayed. Thanks a lot
Posted : 12/08/2022 5:06 pm
Hi Meyanui,
For this you must put your data in the correct tabular layout in a single sheet. You can use Power Query to consolidate the data into one sheet. Then you can create a PivotTable with Slicers to filter the data to show the subdivision you want.
Let us know if you get stuck.
Mynda
Posted : 14/08/2022 7:24 am
Topic starter
Thank You Myanda. I will get back
Posted : 16/08/2022 5:16 am