Pivot across several tabs

T

Tami

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.
 
L

lab-guy

Tami said:
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.
Click to expand...

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
 
T

Tami

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