Hi,

I would like to know whether it is at all possible to run one Pivot
table from data contained within 2 worksheets?

Worksheet 1 contains a repository of Insurance claims payments
Worksheet 2 contains a repository of Insurance premiums received

An example of what I would like to achieve is: -

Mr Smith has paid us £1000 in Insurance Premiums and has made £500
worth of claims. I would like to anaylse this data in one pivot table
and maybe produce some pivot charts showing Mr Smiths claims as a
percentage of premium paid by Mr Smith.

Any help would be gratefully received.

Regards


--
Emyn
------------------------------------------------------------------------
Emyn's Profile: http://www.excelforum.com/member.php...o&userid=16148
View this thread: http://www.excelforum.com/showthread...hreadid=485835

2 worksheets - no problem. DataPivot TableMultiple consolidation
ranges. Pivot shape will depend on the way your data is organized in
the tables.
--
Tomek

Thnx Topola


--
Emyn
------------------------------------------------------------------------
Emyn's Profile: http://www.excelforum.com/member.php...o&userid=16148
View this thread: http://www.excelforum.com/showthread...hreadid=485835