pivot table

[oldLearner57]

hi community

scenario:

i have 5 worksheet, name as, Jan / Feb / Mar / Apr / May,
and
all these worksheets contain similar labels but with different numeric data

is it possible for me to create 1 Pivot Table base on the 5 worksheet data ?
if can...
how can i do it ?

m using xls 2003 pro version

thanks community for assistance given

 

[Peo Sjoblom]

It depends, it is possible to use multiple ranges but the layout will be
different

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


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[oldLearner57]

thanks! got the answer

thanks community as well