Pivot across several tabs
 

can you pivot across several tabs?

i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots but we can't figure out how to
pivot across different worksheets.

Pivot across several tabs
 

"Tami" wrote:

can you pivot across several tabs?

i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots but we can't figure out how to
pivot across different worksheets.

Pivot table with Multiple Consolidation Ranges
ALT Data, Pivot to bring up the wizard

It did create a pivot table with data from 5 different tabs;

Mike

Pivot across several tabs
 

bummer....someone did mention 5 tabs but i need a lot more than that...any
other suggestions?

"lab-guy" wrote:



"Tami" wrote:

can you pivot across several tabs?

i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots but we can't figure out how to
pivot across different worksheets.

Pivot table with Multiple Consolidation Ranges
ALT Data, Pivot to bring up the wizard

It did create a pivot table with data from 5 different tabs;

Mike