How to summarize data
Data summarization is basic need to analyse any data and excel itself provide very great feature for this which is pivot table. pivot table has great feature which you can use to make your data tell you a story. but it takes memory to store data into pivot cache as a cube to faster operation and increase file size.
Many time we don’t really need to have a pivot table we can use some sort of formulas and have our summary page refresh as soon as new data comes in. But again, formulas takes time to recalculate and if it is a large data formulas may hang your file.
Now, we have got a third method to summarize data without having those two issue and this is of course VBA. pretty and simple, you just need to write a chunk of code and it will transform your data into summary and then you can do further charts and all.
This is pretty simple example but this can be very helpful. this table shows your data structure.
Now, we need to transform this data in to summary, We have developed a code in the file which you can download by following the link below. this is very simple code and can create this summary faster than a blink of an eye.