Pivot across several tabs

  • Thread starter Thread starter Tami
  • Start date Start date
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.
 
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
 
bummer....someone did mention 5 tabs but i need a lot more than that...any
other suggestions?
 
Back
Top