Hi all,
I am using Pivot to "table" my datas. It worked well before as my datas are
not exceding 1 page. Now I got about 100,000 set data set. How should I link
them together? Any example?
Thanks

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

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

Naga wrote:
Hi all,
I am using Pivot to "table" my datas. It worked well before as my datas are
not exceding 1 page. Now I got about 100,000 set data set. How should I link
them together? Any example?
Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra,
But What I need is a matrix. It gives me a table.
Please see the example.

Sheet1
From To
1 1
2 1
1 2
2 1

Sheet2
From To
1 1
2 1
1 2
2 1

And I expect the outcome should be

To
From
1 2
1 2 2
2 2 2

But I got,
Row
Col
1 4
2 4


Any Help?
Thanks