how to pivot data from several tabs

[Guest]

I need to pivot different tabs in one pivot table, is it a way to quickly
link all tabs in a data range?

 

[Roger Govier]

Hi

You can create a number of different Pivot Tables all from the same
source data.
Having created the first PT, go through the procedure again.
Give the source data as the same range or same name as you did for the
first. The wizard should ask you if you want to use the same Pivot Cache
to cut down on size, reply yes and point to the first cache.

Repeat the procedure for as many other PT's as you wish, which can be
placed on the same tab or different tabs according to your needs.

 

[Debra Dalgleish]

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 here:

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

 

[Roger Govier]

Ooops!!
Sorry Holly, totally misread your request.