Pivot Table

[Emyn]

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

 

[topola]

2 worksheets - no problem. Data>Pivot Table>Multiple consolidation
ranges. Pivot shape will depend on the way your data is organized in
the tables.

 

[Emyn]

Thnx Topola