Pivot Tables.

[Christopher Naveen]

Hi,

I have 4 sheets and all the sheets have same heading with different data.
Now I am trying to create a common pivot for all the 4 sheets at last (on 5th
sheet). Is it possible to do this action. If yes I request any body to help
me on the same.

Thanks in advance!

-chr

 

[Pierre]

Hi,

I have 4 sheets and all the sheets have same heading with different data.
Now I am trying to create a common pivot for all the 4 sheets at last (on 5th
sheet). Is it possible to do this action. If yes I request any body to help
me on the same.

Thanks in advance!

-chr

Chris, Debra Dalgleish's site will walk you through such an
eventuality.

http://www.contextures.com/xlPivot08.html

Pierre