Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple Consolidation Ranges
Hi
I have found out how to create a normal pivot table from multiple ranges, by using MS Query to join the data. One sample file contains the pivot table, the other contains the source data tables at http://www.contextures.com/excelfiles.html Instead of using two files can I using only one file with the source data tables being in different sheets? I have tried it does not seem to work. Thanks in advance. |
#2
|
|||
|
|||
What happened when you tried it?
nc wrote: I have found out how to create a normal pivot table from multiple ranges, by using MS Query to join the data. One sample file contains the pivot table, the other contains the source data tables at http://www.contextures.com/excelfiles.html Instead of using two files can I using only one file with the source data tables being in different sheets? I have tried it does not seem to work. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi Debra
A message appears "ODBC Excel Driver login failed" "Unrecognised database format" "Debra Dalgleish" wrote: What happened when you tried it? nc wrote: I have found out how to create a normal pivot table from multiple ranges, by using MS Query to join the data. One sample file contains the pivot table, the other contains the source data tables at http://www.contextures.com/excelfiles.html Instead of using two files can I using only one file with the source data tables being in different sheets? I have tried it does not seem to work. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the "Correlation" dialog box with multiple ranges? | Excel Discussion (Misc queries) | |||
rank/small with multiple ranges | Excel Discussion (Misc queries) | |||
Sorting Multiple Ranges | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel |