Quote Originally Posted by tehpuppyryry View Post
Well, that is where the issue currently lies. We are currently using a massive pivot table that we are constantly going in, editing, and ripping out data ourselves to populate the counts. It is an ugly mess and I am trying to create something that uses VBA, and not the current mess that then takes about an hour to digest and then input the data elsewhere. The goal is to move away from it for speed and we have found that Power BI, where the file hopefully will end up, has not liked the previous pivot table.

OK, but my experience with pivot tables is that they're pretty fast and can answer almost any question

I've used PTs to do the heavy lifting and then VBA to extract and format the data if more is required