| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Pivot tabel be linked to multi-tabs? | Excel Discussion (Misc queries) | |||
| Pivot pulling Multiple tabs | Excel Worksheet Functions | |||
| Pivot Table to Tabs | Excel Discussion (Misc queries) | |||
| how to pivot data from several tabs | Excel Discussion (Misc queries) | |||
| Pivot Tables from more than one tabs | Excel Discussion (Misc queries) | |||
Hybrid Mode
