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.
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.
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 here:
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
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 here:
>
>
> 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks