| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
I have a basic understanding of Pivot Tables and have played around
with a few to further my understanding. One thing I'm not clear on is how to use one in a workbook that has multiple tabs. My workbook contains 25 tabs today and I'll likely add more in the future. Can I incorporate all of those tabs into the Pivot Table? The information I'm trying to pull is Name, Address, State, and Zone. I'm using Excel 2008 on a Mac. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
Shane Devenshire wrote a solution here :
http://groups.google.fr/group/microsoft.public.excel/browse_thread/thread/ea6a31201ae138f9/aedc05161906ef9b?hl=fr&ie=UTF-8&q=excel+pivot+table+shane+devenshire+"microsoft. public.excel"+sheets+sql#aedc05161906ef9b Daniel I have a basic understanding of Pivot Tables and have played around with a few to further my understanding. One thing I'm not clear on is how to use one in a workbook that has multiple tabs. My workbook contains 25 tabs today and I'll likely add more in the future. Can I incorporate all of those tabs into the Pivot Table? The information I'm trying to pull is Name, Address, State, and Zone. I'm using Excel 2008 on a Mac. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
