+ Reply to Thread
Results 1 to 2 of 2

Pivot table from multiple worksheets . . . possible?

  1. #1
    Spyder
    Guest

    Pivot table from multiple worksheets . . . possible?

    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!

  2. #2
    Debra Dalgleish
    Guest

    Re: Pivot table from multiple worksheets . . . possible?

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1