My aim is to insert multiple pivot tables on one sheet (BELOW) each other for project expense reporting.
All works fine except for the positioning of the second pivot table insertion point as the top pivot table has different number of output rows per project.
Would a macro running each pivot table be the answer- then to establish the last row of data, insert a blank row before running the next pivot table
Your suggestions are appreciated. I am not very well trained in macro's and would like some inputs please.
Thank you