Hi All,
I have a workbook which has two pivot tables stacked on top of each other which are likely to grow in the coming months as the source data is updated.
What I'm looking for is a macro that can find the bottom of these pivot tables and insert two blank row(s) each to mitigate any overlap errors as the pivot tables increase in size.
Is there a simple piece VBA code to do this?
Thanks,
Jvz_87
I have a workbook which has two pivot tables stacked on top of each other which are likely to grow in the coming months as the source data is updated.
What I'm looking for is a macro that can find the bottom of these pivot tables and insert two blank row(s) each to mitigate any overlap errors as the pivot tables increase in size.
Is there a simple piece VBA code to do this?
Thanks,
Jvz_87