Is it possible for a pivot table to pull from multiple worksheets, provided
the information being pulled has the same number of columns with the same
format?
Thanks for any help!
Is it possible for a pivot table to pull from multiple worksheets, provided
the information being pulled has the same number of columns with the same
format?
Thanks for any help!
If you create a Pivot Table from multiple consolidation ranges, 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.
Spyder wrote:
> Is it possible for a pivot table to pull from multiple worksheets, provided
> the information being pulled has the same number of columns with the same
> format?
>
> Thanks for any help!
--
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