Question: Hi Experts
Need a macro to do the following:-
1. Add a second or may be third or forth pivot table after the first pivot table has already been added in row A3 "3" cell down from the Grand Total "text" in column A
2. The "Grand Total" text in column A can be any where in column A any cell depending on how big the pivot table is.
So the each time i add a pivot table the next one is three cell down in column A after the text "Grand Total" text in column A.
I have already completed the pivot table macro.....NOW just need to add them in sequence of end results.