Thank you very much for taking the time to reply . I have constructed the dashboard in such a way and I'm using excel 2007, that this approach you're proposing will be too time consuming if I combine it with my idea for the dashboard.
Thnx in any case!
Hi,
I am following the vba and dashboard course here at chandoo.org. I tried replicating the kpi dashboard with the sorting technique and apply it to mine.
I would like to combine it with a drop down list where you chose a month and the data changes dynamically and the sorting works perfectly...