Multiple worksheet Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC - 17 Aug 2007 02:02 GMT

Hello,
I've got data that i'd like to put into a pivot table, but the data is over
65,000 rows...is there a way (other than access; b/c i don't know access) to
make a pivot table out of 2-5 worksheets within the same workbook?

Thanks!!!
-JC

Reply to this Message

Wigi - 20 Aug 2007 14:40 GMT

Hi

Choosing Data > Pivottable, you see in the first screen appearing an option
to consolidate ranges. Choose the 3rd option in that screen and select the
different ranges in the following screens.

Signature

Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

> Hello,
> I've got data that i'd like to put into a pivot table, but the data is over
[quoted text clipped - 3 lines]
> Thanks!!!
> -JC

Reply to this Message