How to create reports based on data residing in multiple workbooks
 

I have multiple workbooks with financial data. For this purpose I would
like to plot trends across multiple reporting periods. Ideally I would
like to be able to do this by accessing data in those spreadsheets
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 other
commercially available plug-ins to help with this?

Thank you!


--
Almi
------------------------------------------------------------------------
Almi's Profile: http://www.excelforum.com/member.php...o&userid=34376
View this thread: http://www.excelforum.com/showthread...hreadid=541552

How to create reports based on data residing in multiple workbooks
 

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

"Almi" wrote:


I have multiple workbooks with financial data. For this purpose I would
like to plot trends across multiple reporting periods. Ideally I would
like to be able to do this by accessing data in those spreadsheets
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 other
commercially available plug-ins to help with this?

Thank you!


--
Almi
------------------------------------------------------------------------
Almi's Profile: http://www.excelforum.com/member.php...o&userid=34376
View this thread: http://www.excelforum.com/showthread...hreadid=541552