Tuesday 4 September 2012

VBA Excel: Table Intelligent Sort

This is really an interesting post, will be quit useful in dashboards, scorecards and wherever high UI is needed. Like many statistical applications, data of multicolumn, if user want to sort by many categories the below code will be the best suit.

Tips: If you link the data range with the chart data, you can see real magic. Sooner i will post some free codes under 'CHART' category for chart animations and many :)



Worksheet Snapshot:

No comments:

Post a Comment