How can I build a pivot table from multiple worksheets which are .

R

Richard Stephens

I need to analyze about 60mb of data on different speadsheets in Excel. I am
attempting to build pivot tables to look at the data.

How do I build pivot tables from several different worksheets in a workbook?
All of the data is in columns with column headers but I can't seem to get it
to pivot correctly to give me the results I need.

Please help...
 
D

Debra Dalgleish

If you create a Pivot Table from multiple consolidation ranges, as you
discovered, you won't get the same pivot table layout that you'd get
from a single range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, and you'll have more
flexibility in creating the pivot table.
 
K

Ken Wright

How do I build pivot tables from several different worksheets in a
workbook?

Sheets in question:-

- All identical in structure, especially Columns & Headers, albeit number of
records in each may vary?
- What ranges are to be included from each sheet, eg Cols A:K? - Any other
data outside those ranges?
- Assuming data starts in say Col A, is it safe to assume that every cell in
the range in Col A will have a value in it - If not then can any of the
columns be relied upon to have data in every cell.
- Headers all on same row?
- Any other sheets in the workbook that are not to be counted?
- If so then how do you identify the ones to use?
- How many sheets approx, and how many records between them all (just
approx)
 
Top