I would like to know ...
Why did You open case under VBA Macros, if You want a dashboard?
There are two days data ... it's nice to test weekly/monthly-report?
Why did You want to use other terms than in sample file?
Do You have clear vision of Your wanted dashboard?
If so, then You would add it to sample file too.
Does a simple Pivot table/chart with some slicers suffice? Without a better idea of what you are looking for in terms of a dashboard, I think a pivot table and Date slicer will work for you.
Hi sir,
Please find my requirement, hope my requirement is clear and waiting for reply
I Have excel , in that we update reports on daily basis by adding new sheet
1. i want to combine all sheets in one consolidate master sheet
2, with that consolidated sheet, we want 2 pivot tabel based on criteria
3. so i want below button click function
1. button to Combine all sheet to one master sheet
2. button to Pivot Table1
3. button to Pivot Table2
4. i want Dynamic linked slicers to filter data