Author: smartbiz

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 […]