Build a dynamic dashboard with XLOOKUP and one drop-down
One drop-down cell, four XLOOKUP formulas, and every number on the dashboard updates itself - no PivotTable, no slicer, no VBA in sight.
Reporting
// 2 postsPosts about Reporting.
Posts about Reporting.
One drop-down cell, four XLOOKUP formulas, and every number on the dashboard updates itself - no PivotTable, no slicer, no VBA in sight.
Paste Link turns three Excel cells into a PowerPoint object that updates itself, once you stop letting the linked range look like a spreadsheet.