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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with source spread across multiple worksheets 1
Pull data from different worksheets/tab into one Pivot Table 3
Pivot table data source 1
Creating pivot table to Existing worksheet 1
Consolidate information from multiple pivot tables 2
Pivot Tables 1
Pivot Table newbie help.. 1
Pivot Tables- SQL Alias' & Field Lists 1

Top