Trying to enter data in the pivot table from different locations on a worksheet. Pivot table wizzard allows only single entries from a single range. Is there a way toombine data for a pivot table?
many thanks
profcw
Trying to enter data in the pivot table from different locations on a worksheet. Pivot table wizzard allows only single entries from a single range. Is there a way toombine data for a pivot table?
many thanks
profcw
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 in a database, and base the pivot table on
that. You'll have more flexibility in creating the pivot table.
prof cwpalmer wrote:
> Trying to enter data in the pivot table from different locations on a
> worksheet. Pivot table wizzard allows only single entries from a single
> range. Is there a way toombine data for a pivot table?
> many thanks
> profcw
>
>
--
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