| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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 he 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I build a pivot table from multiple worksheets which are . | Excel Discussion (Misc queries) | |||
| Pivot table retrieving data from several worksheets | Excel Worksheet Functions | |||
| Can I combine two worksheets into one pivot table? | Excel Worksheet Functions | |||
| How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
