Pivot cache using vba - Type mismatch error

Originally Posted by rorya

How many rows of data do you have?

The data has to be dynamic since it can change on a month on month basis.