Can Pivot tabel be linked to multi-tabs?
 

Due to capacity constraint, data are cut into multi-tabs. How to create Pivot
out of all of them, if possible?

Thanks!

Can Pivot tabel be linked to multi-tabs?
 

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

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

Perhaps you could store the data in a database instead, and base the
pivot table on that.

yhoy wrote:
Due to capacity constraint, data are cut into multi-tabs. How to create Pivot
out of all of them, if possible?

Thanks!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com