Pivot Table - Multiple Worksheets
 

Hi,

I have two spreadsheets in separete workbooks containing various type
of differing data under different column headings. I would like t
anaylse the data contained within the spreadsheets using 1 Pivo
Table.

I have tried using the Pivot Table wizard and opting for Multipl
consolidated ranges, however, this still only lets me look at data fro
1 workbook at a time and does not allow me to analyse data from bot
workbooks at the same time.

Is there anyway I can do this?

Thanks

Emy

--
Emy
-----------------------------------------------------------------------
Emyn's Profile: http://www.excelforum.com/member.php...fo&userid=1614
View this thread: http://www.excelforum.com/showthread.php?threadid=38344