Need to create Pivot table in 2 different sheet

[skr971]

Hi all,

i need a help, i want to analyze a data to creating a pivot table but my data are 2 different excel sheet..

is it possible to create a pivot table with using 2 different sheets data

plz help if any one knows

Thanks
Sunil Kumar

 

[VoG]

Yes it is possible - see http://www.contextures.com/xlPivot08.html

 

[skr971]

Many Many Thanks it's works