Hi All,

I have got 2 pivot tables on the same sheet. 2nd pivot table is below 1st pivot table and excel doesn't allow to overlap pivot tables. so i want to insert rows when we refresh 1st pivot table. below code will give me number of rows in the 1st pivot table.

Please Login or Register  to view this content.
I want to have 2 blank rows between the 2 pivottables.

I would really appreciate your help.

Thks

Nazim