ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/227188-pivot-tables.html)

[email protected]

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.

Daniel.C[_3_]

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.





All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com