Hi,

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

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

Is there anyway I can do this?

Thanks

Emyn