How to create reports based on data residing in multiple workbooks

A

Almi

I have multiple workbooks with financial data. For this purpose I woul
like to plot trends across multiple reporting periods. Ideally I woul
like to be able to do this by accessing data in those spreadsheet
without doing cut/paste and creating a whole new pivot table.
The question is: Can this be done in Excel. And if not are there othe
commercially available plug-ins to help with this?

Thank you
 
G

Guest

Almi,

It is possible to combine data from different workbooks using MS Query and
use that query as a basis for a pivot table.

Check out this page on Debra's Dalgleish's site:

http://www.contextures.com/xlPivot08.html

At the bottom of the page will be a link to a sample file describing how to
do this.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create multiple new workbooks based on sort criteria 7
How to combine multiple workbooks with same structure data 8
Can we connect Pivot to multiple source data (MS Access) 6
How do I change data that has been entered in a column to a row? 2
Building reports in Excel, for data being entered in MultipleWorkbooks by Multiple users 3
dynamic reference to data in multiple closed workbooks 2
Create Charts based on data in Table 1
how to enter data on multiple workbook at the same time 3

Top