pivot table
 

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 :)
--
oldLearner57

pivot table
 

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" wrote in message
...
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 :)
--
oldLearner57

pivot table
 

thanks! got the answer :)

thanks community as well
--
oldLearner57


"Peo Sjoblom" wrote:

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" wrote in message
...
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 :)
--
oldLearner57