Use showpages command for more pivot tales
 

Hi all,
I have a problem. I have to compile a VB macro taht will build, from the
same data sheet, 2 different pivot tables with same pagefield. Then I have to
create, for every pagefield (common in the 2 pivot), a new worksheet that
contein both pivot. I know that for 1 pivot I can use the showpage command
that does that for a singular pivot...but for the other one?

Anybody knows something about that?

Thx
Tommy