Hi,

I have two pivot tables (in two diffrent wooekbooks) containg the same set of data. The difference is that in table 1 I have forecast and in table 2 actuals. What is the best way to create a third table showing the differences between table 1 and 2. The data is not always sorted the same way in table 1 and 2.

I appreciate all your help,
Thanks in advance,
Martin