Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Question
Hi everyone...is it possible to run a pivot a table on mulitple worksheets in
a work book? I have two spreadsheets that are two large to place on one worksheet....but I need to consolidate the file in some reasonable way. Any help would be wonderful! -- Jules |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Question
You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want. There's more information he http://www.contextures.com/xlPivot08.html Jules wrote: Hi everyone...is it possible to run a pivot a table on mulitple worksheets in a work book? I have two spreadsheets that are two large to place on one worksheet....but I need to consolidate the file in some reasonable way. Any help would be wonderful! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
Date gaps in chart after pivotTable | Charts and Charting in Excel | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
PivotTable question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |