Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table with multiple worksheets
Hi,
Sorry but I have gone through all help programs and cannot find how to make a pivot table with multiple worksheets.Any help would be great. |
#2
|
|||
|
|||
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single range. There's an example he http://www.contextures.com/xlPivot08.html If possible, store your data on a single worksheet, or in a database, and base the pivot table on that. You'll have more flexibility in creating the pivot table jo74 wrote: Hi, Sorry but I have gone through all help programs and cannot find how to make a pivot table with multiple worksheets.Any help would be great. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanx Debra. I have tried again but not getting what I want from it.
Each sheet has the type of truck in Col A, Rego in Col B and so on. Each sheet has a city name. I am wanting to have a table on last sheet of showing how many of each type are in each town. Can you help? "Debra Dalgleish" wrote: You can create a Pivot Table from multiple consolidation ranges, but you won't get the same pivot table layout that you'd get from a single range. There's an example he http://www.contextures.com/xlPivot08.html If possible, store your data on a single worksheet, or in a database, and base the pivot table on that. You'll have more flexibility in creating the pivot table jo74 wrote: Hi, Sorry but I have gone through all help programs and cannot find how to make a pivot table with multiple worksheets.Any help would be great. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
Pivot table from multiple worksheets . . . possible? | Excel Discussion (Misc queries) |