Pivot Tables using VBA

Had an interesting case the other day.

How to create a pivot table with 60,000 rows that uses the data from 500,000 rows and the aim was to count by month how many unique employers each of the 60,000 customers had in each month.

So a little VBA to the resuce and in less than an hour a new worksheet called “Show me the data” was created.

One can only imagine how long mere mortals would to try to manipulate the data to achieve their desired report!

So sometimes when you have a hammer, you sometimes need a different tool if the target isn’t always a simple nail.