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