Dear Steven:
Thank you very much for your reply and advice.

I am curious now how to create a Pivot Table from multiple sheets. Whenever
I try it fails or doesn't allow me to access the Pivot Table/Pivot Chart
Report menu option. If you or anyone else has any insight on this, please
let me know.

Thanks.


--
-=- penciline -=-


"steven1001" wrote:


If you organise your data as follows:

Date source Account Value
1/2/06 Cash News 2.50
1/2/06 Debit Food 21.50
1/2/06 Charge Clothes 52.50
1/2/06 Charge News 12.50
1/2/06 Cash Food 31.50
1/2/06 Charge Clothes 102.50

Then a pivot table can easily summarise.
Example
In ROW drag labels of Date and Account
In COLUMN drag label for Source
In DATA drag label for Value

The pivot table will create itself.

Create a second pivot table from the first (Using Source = from
another Pivot Table) if you want an additional view say with Date and
Source as row headings and Account as Column headings.

regards..


--
steven1001

--
-=- penciline -=-

"penciline" wrote:
... how to create a Pivot Table from multiple sheets ..

Perhaps take a look at Debra's page at:
http://www.contextures.com/xlPivot08.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Dear Max:

I am having difficulty with this setup of choosing multiple consolidation
ranges. When I choose a pivot table from a single sheet, it comes out
correct, with the correct column and row categories that I want to pivot.
When I choose multiple consolidation ranges, I only get minimal data
categories. For example, in my snigle-sheet pivot table I have "category"
(art supplies, books, clothing, electronics, etc.) as groups that show how
much I purchased in each group/category. But in the multiple-sheet pivot
table, those categories are missing and I cannot pivot them. I have gone
about the process of selecting ranges exactly the same way in each type of
table, but for some reason the multiple-sheet table is missing this important
data.

Please let me know how I can properly set up my pivot table.

Thanks in advance for your help.
--
-=- penciline -=-


"Max" wrote:

"penciline" wrote:
... how to create a Pivot Table from multiple sheets ..

Perhaps take a look at Debra's page at:
http://www.contextures.com/xlPivot08.html
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

The limitations you mention are acknowledged in Debra's page under:
"Limitations of Multiple Consolidation Ranges", with some suggested
"work-arounds", eg: to quote: "If possible, move your data to a single
worksheet ... ". Hang around awhile, perhaps Debra herself may pop by here
and offer you more insights ..

P/s: I'm eagerly awaiting Debra's new book:
"Excel PivotTables Recipes"
to reach this part of the world <g ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"penciline" wrote in message
...
Dear Max:

I am having difficulty with this setup of choosing multiple consolidation
ranges. When I choose a pivot table from a single sheet, it comes out
correct, with the correct column and row categories that I want to pivot.
When I choose multiple consolidation ranges, I only get minimal data
categories. For example, in my snigle-sheet pivot table I have "category"
(art supplies, books, clothing, electronics, etc.) as groups that show how
much I purchased in each group/category. But in the multiple-sheet pivot
table, those categories are missing and I cannot pivot them. I have gone
about the process of selecting ranges exactly the same way in each type of
table, but for some reason the multiple-sheet table is missing this
important
data.

Please let me know how I can properly set up my pivot table.

Thanks in advance for your help.
--
-=- penciline -=-